Filtering Data in Alteryx with Two Excel Files

Bharat_CR

Hello Alteryx Community!
Can you please help me with this?
I have two input files. The goal is to filter the data in File 1 according to the criteria outlined in File2.
File1 comprises multiple columns, while File2 holds filtering criteria, consisting of column names from File 1 and associated values for filtering. 
Sample:-
File1(Data):
Data

File2(Filters):
Filters

I have big dataset, so I've got a list of filters and the list is subject to change.

Any assistance in the logic and workflow is greatly appreciated!

Gawa

hi @Bharat_CR 

Please see the attached workflow and snapshot.

It was not clear whether you want to filter records which meets any criteria(OR Logic) or all criteria (AND logic), so I created 2 ways. You can pick either one which better fits to your case. 

1201853_gawa.yxmd