I am just learning to program with Alteryx.
I have a question about adding a column with a unique numbering for each group of similar values in the column 'Name'
My table I have now looks like this:
ID | Name | Goal Type | Feasibility | |
121 | John | x | 0.99 | |
121 | John | x | 0.58 | |
343 | Martin | x | 0.99 | |
343 | Martin | x | 0.80 | |
343 | Martin | x | 0.83 | |
343 | Martin | y | 0.99 | |
343 | Martin | y | 0.99 | |
I would like to have an extra column that numbers the names. Each time a new group of names comes up, the count starts from the start.
ID | Name | NR | Goal Type | Feasibility |
121 | John | 1 | x | 0.99 |
121 | John | 2 | x | 0.58 |
343 | Martin | 1 | x | 0.99 |
343 | Martin | 2 | x | 0.83 |
343 | Martin | 3 | x | 0.83 |
343 | Martin | 4 | y | 0.99 |
343 | Martin | 5 | y | 0.99 |
Does someone know a tool and code that helps add a unique count for each name as in the example above?
Thank you!
Solved! Go to Solution.
Yes! Works perfectly.
Thanks