Filter multiple files with same filter

Question

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?

Ronit_Gupta · Answer

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?

Sample workflow Filter Tool 240108.yxmd

Qiu · Answer

Can you provide sample input and output?

apathetichell · Answer

https://help.alteryx.com/current/en/designer/apps-and-macros/macros/batch-macro.html