Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filtering Data in Alteryx with Two Excel Files

Bharat_CR
5 - Atom

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):
DataData

 

 

 

 

 

 

 

 

 

File2(Filters):
FiltersFilters

 

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!

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

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. 

image.png

Labels
Top Solution Authors