Hello,
I have an excel file like shown below.
foreach row i want to see if the decision column =“3”
If it is i have to search for all the identical chronos and put both lines in excel file
Example :
Row 2 should be in the new excel file because it contains 3 in the decision column
Row 3 should be in the new excel file because it contains 3 in the decision column
Row 4 also should be in the new excel because it has the same chrono than the chrono of line 3
PS: I have a column where you can find all the positions of the lines if needed.
Can anyone help me please
Did u try with JOIN datatable activity
Have a view on this doc on how to use it with and example
https://docs.uipath.com/activities/other/latest/workflow/join-data-tables
Cheers @Dhouha_Cherif
1 Like
filterdt=dt.asenumerable.where(function(x) x(“decision”).tostring.equals(“3”)).copytodatatable
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.