Excel filter on the base of another sheet data

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)


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

Now use below

Hope this will help you


its useless, I have already tried it

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

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