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!
Solved! Go to 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
Yes this works! Thanks!