Rule-based Row Spliter - Missing

[drabbit]

Hy there,

im trying to use the Rule based Row Spliter to validate my data…

So i want to see if the columns got the right value and if there are values missing.

So for missing I don’t get it and i don’t know why…

Here is an example of my table:

Col1 | Col2
A | B
A | C
| L
| B

And this is the code i use:
$Col1$ = “A” => TRUE
$Col2$ = “B” OR $Col2$ = “C” => TRUE
MISSING $Col1$ => FALSE
TRUE => FALSE

Is there something wrong how i use “Missing” and is there maybe an other way to validate data?

thank you

[HansS]

Hi @drabbit

re-ordering your rules may help

MISSING $Col1$ => FALSE
$Col1$ = “A” => TRUE
$Col2$ = “B” OR $Col2$ = “C” => TRUE

gr.
Hans

[drabbit]

Hi @HansS

thank you - re-ordering helped

br Daniel

[ipazin]

Hi there @drabbit ,

all Rule nodes have the same logic which is:

“The first matching rule in order of definition determines the outcome.”

Br,
Ivan