Hi I wanted to count all the Successful and Failed transaction inside fore each row.
I have to fore each row (Stage 2 & Stage 3) in workflow Below.
Here is the Structure of my (Stage 2)
the output should looks like this in excel.
how can i Do that?
Thank you in advance.
Hi @Vincent_Nuestro
Looks like the condition row(“RPA”).ToString = “” will set the variable FlowState to “Success” instead of skipping [Continue activity].
So you could count all the datatable rows with this condition, row(“RPA”).ToString = “”
Success
DT.AsEnumerable.Where(Function(x) x.Item(“RPA”).ToString = String.Empty).Count
Failed
DT.AsEnumerable.Where(Function(x) x.Item(“RPA”).ToString <> String.Empty).Count
note: DT is DataTable variable
1 Like