Count the String

Shubham_Akole · July 3, 2020, 9:20am

Hi,
I want count Number of “Yes” for each ID…
I Provide File …

I want…
ID | Count
36 | 1
20 | 3

Please Help…Count.xlsx (8.2 KB)

William_Blech_Sister · July 3, 2020, 10:23am

Plese have a look at my workflow, it does exactly what you want

Please like my post and mark my answer as a solution, it helps me
Any questions please let me know

Thanks

Shubham_Akole · July 3, 2020, 10:30am

It show invalid Activity …What package i want to install??

William_Blech_Sister · July 3, 2020, 10:39am

This one:

Standing by for you to let me know if it worked!

Thanks

Shubham_Akole · July 3, 2020, 10:58am

I change the column name “ID” to “Employee ID”…
But in the Count Activity it show error “Count: Syntax error: Missing operand after ‘ID’ operator.”

William_Blech_Sister · July 3, 2020, 11:01am

Please change the “Select” argument in the Count activity property.

Almost there!
Standing by in case you need something else

samir · July 3, 2020, 11:10am

I’ll suggest you to follow steps below

Read Range to get main data in dt var.
get uniqueID using dt.DefaultView.ToTable(True,"ID")
use for each row on uniqueID to filter dt by using unique Id and Yes in Discrepancy and get count.
use add data row to store ID and count in separate datatable.

Check this workflow, to get exact idea —> test.xaml (10.5 KB)
Note —> Don’t forget to mention file path in workflow.