Excel filter on the base of another sheet data

Help Activities
, ,
1

Please help me to filter the excel sheet

I wanna filter the whole datatable.
first It check the “Incident Type” then “Department” then “Plant” from comparing sheet to RAW sheet. in result it write the all matching row in match sheet and rest of the rows in unlatching sheet.

please help me.
01.xlsx (98.6 KB)

2

@Dmitri00007

Use Filter Datatable and from the RAW sheet only extract the required columns

Now use below

Hope this will help you

Thanks

3

its useless, I have already tried it

4

Hi @Dmitri00007

There are multiple ways in UiPath to filter DataTable.

Please refer the below and implement as per your requirement.

Hope this will be helpful. Thank you.

1 Like
5

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