Classification rule to differentiate 0 and non-zero | Community
Skip to main content
vickyg28253246
vickyg28253246
Level 3
October 2, 2018
Solved

Classification rule to differentiate 0 and non-zero

  • October 2, 2018
  • 2 replies
  • 1149 views

I need tt classify the stock position as Y(if value > 0) or N (if value = 0). Since numeric classification is not available, I tried a brute force approach - creating 10 rules with "starts with" (see screenshot).

This has worked for non-zero values, but failed validation if the value is 0.

What are other options?

Thank you

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Urs_Boller

use a workaround:

- Rule 1: set regex "*" to "N" (everything...)

- Rule 2: set regex "^[1-9]" to "Y"

first, all vaules get "N", but those matching the Rule 2 will get "Y" ...

remark: the classification will take the last match, just use the test interface...

2 replies

Urs_Boller
Community Advisor
Urs_BollerCommunity AdvisorAccepted solution
Community Advisor
October 2, 2018

use a workaround:

- Rule 1: set regex "*" to "N" (everything...)

- Rule 2: set regex "^[1-9]" to "Y"

first, all vaules get "N", but those matching the Rule 2 will get "Y" ...

remark: the classification will take the last match, just use the test interface...

    vickyg28253246
    vickyg28253246Author
    Level 3
    October 3, 2018

    Thank you, makes sense.

    Terms & ConditionsAccessibility statement

    Loading footer...