This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.