Count the String

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)

Hy @Shubham_Akole,

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 :slight_smile:
Any questions please let me know (34.2 KB)


1 Like

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


This one:

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


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.”

Hy @Shubham_Akole

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

Almost there!
Standing by in case you need something else

Hi @Shubham_Akole,

I’ll suggest you to follow steps below

  1. Read Range to get main data in dt var.
  2. get uniqueID using dt.DefaultView.ToTable(True,"ID")
  3. use for each row on uniqueID to filter dt by using unique Id and Yes in Discrepancy and get count.
  4. 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.