Group by multiple columns to get a group unique ID

[Dazzerman]

Hi @Sam7 

You can use the Tile Tool under the Preparation tab.  Then if you select "Unique value" as the Tile method, then select the Unique columns you want to specify, you get a unique tile ID for each group, and even a sequence number thrown in as a bonus!!

🙂

Hope this helps.

[danilang · Accepted solution]

Hi @Sam7 

Your problem statement is somewhat ambiguous, but if you're looking for a solution that will work for any number columns that may or may not be present at any time, the following will create groups based on all the columns available during that run.  

Add a record ID, transpose all the columns and then concatenate all the values in the rows.  Join this concatenated value back to the original data and use this in a multi-row to set the groups.  

This solution uses all the columns in your data set to create the groups, resulting in 10 groups in total.  If this isn't what your looking for, post back here with details about exactly which fields you compare to make your groups.

Dan