I am looping through the each row. I have 7-8 columns.
So, I am trying to get the “True” Value count from each row.
M A E N Dos Day
True True False True 1
False False True False 5
True True True False 8
in the Above table for the first iteration i need a count as 3 because we have only 3 True values
in the second iteration i need a count as 1
in the third iteration i need a count as 3
Hi @404_Error ,
please follow below steps
- use for each row to loop the datatable
- Inside use for each activity to loop columns dt.Columns
- inside check if condition
- if yes increase count to intCount=intCount+1
- outside of for each row(“Day”)=intCount.ToString()
Use for loop on the datatable and then use this inside to get the count
Total = currentrow.Itemarray.Count(function(x) x.ToString.Equals("True"))
Atlernately on excel you can use countif formula and use autofill range activity
i was trying the same but in different way.
now i resolved it.
Thank you once again
Checkout this expression
Use this inside the For each
This solution worked for me, thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.