Subset of a data from the data table for a specific Use Case

Hello RPA community,

I have a specific use case which i am currently working on.
The data is stored in an excel grouped by a Col A (Change request).

i want to store all the rows tied to the same Change request number as a subset in a data table and then operate on them.

Then in the subsequent iteration, store the next grouped Change Request number records and operate on them, like wise…

Please can you help me to achieve this.
Sample Data shared.

@ajagtap636
Assign activity
Left: TableList | DatTYpe:List(Of DataTAble)
Right:

(From d in YourDataTable.AsEnumerable
Group d by k=d(“Change Request”).toString.Trim into grp=Group
Select g=grp.CopyToDataTable).toList

Then with a for each and a nested for each row you can process the groups and its members

also have a look here:

Thank you this is really helpful and the above solution worked. I was able to get the subset of the Change request and loop through it.

However I wanted little more help with respect to logic. It is passing for the happy scenario but does not work for one specific scenario.

Condition: For one change request, check if all the implementation Task (“Short Description”) are closed and then check the “Post Implementation task”. If Post Implementation task is open send out email notification.

My logic is failing if either one of the Implementation task is “Open”.
Attached the Main.xamlMain.xaml (12.9 KB)

Actually found the solution. Thanks.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.