Grouping of data based on String columns

[Tej_Singh]

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.

[atcodedog05 · Accepted solution]

Hi @Tej_Singh 

You can do this with help of Tile tool unique value config.

Workflow:

Hope this helps : )

[messi007 · Accepted solution]

@Tej_Singh,

Tile tool will do the job for you:

Attached the workflow,

Regards

[Tej_Singh]

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! 🙂 🙂

[Tej_Singh]

Thanks @messi007  your solution is also same as above. Thank you it works. 🙂

[atcodedog05]

Happy to help : ) @Tej_Singh 

Cheers and have a nice day!