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.
