Classification rule to differentiate 0 and non-zero | Community
Skip to main content
vickyg28253246
vickyg28253246
New Participant
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

vickyg28253246
vickyg28253246Author
New Participant
October 3, 2018

Thank you, makes sense.

Urs_Boller
Urs_BollerAccepted solution
New Participant
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...

    Terms & ConditionsAccessibility statement

    Loading footer...