automatically create the filter workflow based on the condition
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
 
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
can you please share some snapshot?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)