Need to group the below data in the following format based on Key. Within each key group number starts from 1 and then keep increasing.
Input:
KEY | VALUE |
ABC101 | 10 |
ABC101 | 3 |
XYZ201 | 4 |
XYZ201 | 99 |
ABC301 | 12 |
ABC101 | 31 |
ABC301 | 1 |
XYZ201 | 0 |
OUTPUT (ignore bold formatting as it is only for understanding purpose)
KEY | VALUE | GROUP |
ABC101 | 10 | 1 |
ABC101 | 3 | 2 |
XYZ201 | 4 | 1 |
XYZ201 | 99 | 2 |
ABC301 | 12 | 1 |
ABC101 | 31 | 3 |
ABC301 | 1 | 2 |
XYZ201 | 0 | 3 |
How can I achieve this in Alteryx? Will tiles tool work as it take number column for tiling? My grouping is based on string column.
Solved! Go to Solution.
Hi @Tej_Singh
You can do this with help of Tile tool unique value config.
Workflow:
Hope this helps : )
Thank you @atcodedog05 for such a quick solution. I guess the right option to choose with Tile tool was Unique Value. unfortunately I was playing with all other options except this. Glad I posted here. thanks once again! 🙂 🙂
Thanks @messi007 your solution is also same as above. Thank you it works. 🙂
Happy to help : ) @Tej_Singh
Cheers and have a nice day!