Filter data table using more than one primary key


There is two different sheets in an excel(duplicate and matched).

I have to filter matched sheet based on 2 primary key, CC and Amount.

I tried a logic which allows me to filter one column at a time. Attached the same here. (147.1 KB)

Can anyone help me to modify this code?


CC and Amount column exist on both sheets…

Have you tried using the filter data table activity?



Is it possible to filter 2 data tables at a same time using filter data table ?

@shajanjose With one filter data table activity, you cant filter 2 data tables at a time. Either you have to use 2 separate filter data table activity or if the filter is same for both the tables then you can create a separate workflow and pass datatables as arguments.