Classification rule to differentiate 0 and non-zero

Avatar

Avatar

vickyg28253246

Avatar

vickyg28253246

vickyg28253246

02-10-2018

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 youtd_capture1002.JPG

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

485

Correct Answer

250
ursboller
MVP

02-10-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...

Answers (1)

Answers (1)

Avatar

Avatar

vickyg28253246

Avatar

vickyg28253246

vickyg28253246

03-10-2018

Thank you, makes sense.