Hello,
I try to count the number of missings value (also the number of filled values) PER ROW and i'm blocked....
1/ First i use a column loop (all my interesting columns are String),
2/ I use after a rule engine to fixe the value to "0" to all missing values and "1" if the value is filed
3/ I convert all my columns in number with String To Number Node
4/ and finally, i want to sum all the 1 per row an in additionnal column
Is correct approach ?
The Step 2/ doesnt work , in my rule engine i try this code
MISSING $${ScurrentColumnName}$$ => "0"
TRUE => "1"
and in the Flow variables Tab i fix the replace-column parameter to 'currentColumnName'
It dosent work
Regards