HOW CAN I COUNT NUMBER OF MISSING VALUE PER ROW

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

 

Hello,

maybe transpose your table with the Transpose node and then use the Value Counter in the Analytics.

 

Good luck

Hi both,

the column aggregator can do this.

Cheers, Iris 

5 Likes

nice easy solution, thanks a lot.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.