automatically create the filter workflow based on the condition

[VK11]

Hello All, I have the 3 set of part details(XXXX-100,YYYY-100,ZZZZ-100) which is marked as 1,2,3 in count column. I can filter this by adding 3 separate filter workflow "manually( drag and drop the filter workflow from preparation tab)" in alteryx. Is there any method to create 3 filter tool automatically in alteryx based on input condition?  I have added the input file. kindly help. Thanks in advance

VK

 

[sparksun]

In Result windows, just click the column name you want to filter on, select filter menu and set filter condition, click “Apply“ and then click Apply Data Manipulations check mark, Alteryx will automatically create a filter tool on the canvas. Then you just copy&paste the filter tool twice and simply change the filter condition, it is much more efficient than purely manual way.

[VK11]

can you please share some snapshot? 

[VK11]

Thanks for the response, I have used the copy and paste method to add the filter tool and changed the filter condition (in manual method), but I would like to do with macro or with formula or coding. Thanks

[Qiu]

@VK11 
I dont think there is a feature that we can create th filter tools in batch.
What will be the process after the filter?

Maybe we can batch process what you need without "hard" filter tool.

[sparksun]

In Result window, you can automatically create filter tool on the canvas.

But I don't think you can make it in batch. Depends on how you will process the data, maybe we can find some best solution for you.