Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multi/Dynamic Record ID

MichaelB1
5 - Atom

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 IDColor
1Orange
2Orange
3Blue
4Blue
5Blue
6Blue
7Green
8Green

 

Multi/Dynamic Record ID

 

Record IDColor
1Orange
2Orange
1Blue
2Blue
3Blue
4Blue
1Green
2Green

 

Thanks!

2 REPLIES 2
cpituley
8 - Asteroid

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
5 - Atom

Yes this works! Thanks!

Labels