Filter data table using more than one primary key

[shajanjose (Maria Jose Shajin L)]

Hi,

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.

sample3.zip (147.1 KB)

Can anyone help me to modify this code?

Thanks,
Jose

[shajanjose (Maria Jose Shajin L)]

CC and Amount column exist on both sheets…

[CBlanchard (Cammaron)]

Have you tried using the filter data table activity?

[shajanjose (Maria Jose Shajin L)]

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

[Madhavi (K)]

@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.