Assigning sequences

[mystasz]

Hi Community,

What's the best way to find the Sequence column? I'm struggling to find the best method for my dataset. 

[flying008]

Hi,@mystasz 

maybe you need Tile for sequences.

[mystasz]

I tried the tile tool and used the unique method and grouped by all columns. Is there another tile method I should be using?

[Qiu · Accepted solution]

@mystasz 
Another approach is that we can use the Grouped RecordID macro from the Gallery.

https://community.alteryx.com/t5/Public-Community-Gallery/Grouped-RecordID/ta-p/919203