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
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?