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
Solved! Go to Solution.
Views
Replies
Total Likes
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...
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...
Thank you, makes sense.
Views
Replies
Total Likes