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!
Solved! Go to Solution.
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.