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

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

Dynamic Record ID.yxmd