Data Table question

Help
4

HI @Nitin2606

So your source is a excel i suppose. Read the excel and the data will get stored in a datatable.
Now, follow the below steps.

  1. Add a For Each Row activity

  2. Create a variable “VName” as String data type. (Name can be anything)
    Within the loop

    • Use Assign activity to capture the value of the current row. Assign the value to the variable you created. To capture the value, use below
      Row("Name").ToString

    • Use another assign activity within the loop to capture the count of that value. This will give the count of each name. To get the count use below

    YourDataTable.Select("Name = '" + VName + "'").Count - Vname is the variable we created above to hold the name of each row within the loop

1 Like