Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Splitting data


The filter tool is great for splitting the data into two pieces based upon a condition.  That is the true goes one way and the false goes another.  Is there a tool to split the data into multiple sets based on a condition, or do you have to use multiple filter tools?



Hey @afinzerillo,


The best way would be multiple filters, but if this is something you need to be dynamic for different processes I would recommend building a macro to execute a certain number of filters and it could even be possible to do some type of iterative macro to do this.


You can either use multiple filters or a batch macro depending on what you'd like to achieve. Benefit of the latter is that it allows you to split the data dynamically depending on how many unique values you have in your data for instance.