Dynamically splitting a dataset based upon all values in a field

Question

Hi all

I'm trying to split a dataset automatically based upon the values in a field. I would use a Filter to do this for a specified value, however, I want to do this dynamically for all values within the field. This field is likely to include additional, different values in the future.

As a simple example, if I was to split the attached table based upon their Group dynamically, how would you suggest going about this?

Thanks

Harry

example.xlsx

DataCurious_Shaan · Answer

Hi Harry, that makes sense. A tile tool will be able to create more dynamic groups based on the data it sees. But trying to split out a group will then need to be defined somewhere in the workflow

HSuffolk · Answer

Hi Shaan

Thanks for your help.

I've studied your workflow - this works perfectly for a defined group of 2, however, is this possible to do without having to define 2? For example, if I was to import new data next week into the input file that included groups 6,7,8,9,10, and I had repeated this workflow only for groups 1-5, this then wouldn't split out the new groups automatically. Does that make sense?

Thanks

Harry

DataCurious_Shaan · Answer

Alternatively, you could use a tile tool to bucket the data on unique values.