is there a quick way to separate data for analysis

Bigmonki

I have an input where the data is defined by a table ID. Each table has multiple rows, so I would like to use the table ID and separate it's data from the other tables. 

This is kind of like a multiple filter but I wanted to know if it is possible to achieve the split using fewer tools and be more dynamic. If I user a filter, every time there is a new table, I would have to go in and add a new filter.

May data looks like this:

My workflow currently looks like this, but the filter isn't dynamic on the 'Table' name:

Is there a tool that would allow me to implement the dynamic split based on the column?

Data split example.yxzp

mceleavey

Hi @Bigmonki ,

You can wrap the entire thing in a batch macro and feed the grouped TableID column as the control parameter value. Attach this to the filter and you then will have a macro processing each one individually.

However, depending on what you want to there may be other ways of handling it. 

M.