Alteryx Designer Desktop Discussions

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

Filter multiple files with same filter

RonitGupta
7 - Meteor

I have a condition to filter say P1 in a column with one input file and then I change the filter value to P2 and run the workflow. Exactly the same process I am repeating with another filter with second input file. Is there a way to control both the filters with one condition so that I don't have to change it twice? As I need P1 in the both filters and run the workflow to get output then update P2 in both filters and then run the workflow to get output.

 

How this can be simplified? Is it also possible to run once and I can get output with P1 filter and P2 filter appended in same output sheet?

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

Can you provide sample input and output?

Ronit_Gupta
5 - Atom

Here is sample workflow. 

 

Scenario -1

Can both filters be combined? Purpose is to update filter only once

 

Scenario-2

Can automatically change filter value to P1 & then P2 and get the appended output by running workflow once?

Can filter value be fetched in formula tool maybe using summarize tool after filter & joining the two tables? 

 

Labels