counting filled slection of columns per row
Dear all,
I have a result table from pivot that you can find in attached workflow.
In a new column I have to count the number of filled columns
1.0+first(a)
2.0+first(a)
…
20.0+first(a)
in pseudocode:
gn_count = 0
for i = 1 to 20
if column(i & “first(a)” is not null
gncount = gncount +1
endif
next i
column(“count)”=gn_count
I tried with column aggregator but I foundno way to define the condition.
Any idea?
Thx for help!
BR,
Heinz