Multi/Dynamic Record ID

[MichaelB1]

Hi Alteryx Community,

This is my first post here. Seems like an easy enough of question not sure why I can't figure it out myself.

I want to assign a RecordID (1,2,3) that resets after a change in values in another field. I assume this is a task for a multi-row formula? Please let me know.

Normal Record ID:

Record ID	Color
1	Orange
2	Orange
3	Blue
4	Blue
5	Blue
6	Blue
7	Green
8	Green

Multi/Dynamic Record ID

Record ID	Color
1	Orange
2	Orange
1	Blue
2	Blue
3	Blue
4	Blue
1	Green
2	Green

Thanks!

[cpituley · Accepted solution]

Hi @MichaelB1, 

Please find attached a workflow that accomplishes what you are looking for. 

You want to use the tile tool configured to "Unique Value".

Let me know if this works for you. 

Kind regards,

Cameron

[MichaelB1]

Yes this works! Thanks!