Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to give similar values a unique numbering in an extra column

RK3
6 - Meteoroid

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:

     
IDName Goal Type Feasibility 
121Johnx0.99 
121Johnx0.58 
343Martinx0.99 
343Martinx0.80 
343Martinx0.83 
343Martiny0.99 
343Martiny0.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. 

 

IDName NRGoal TypeFeasibility
121John1x0.99
121John2x0.58
343Martin1x0.99
343Martin2x0.83
343Martin3x0.83
343Martin4y0.99
343Martin5y0.99

 

Does someone know a tool and code that helps add a unique count  for each name as in the example above?

 

Thank you! 

 

3 REPLIES 3
cmcclellan
13 - Pulsar

Does a running total work for you ?

 

2018-11-16 23_22_47-Alteryx Designer x64 - New Workflow3_.png

jdunkerley79
ACE Emeritus
ACE Emeritus

I suggest a multi row formula tool


2018-11-16_12-38-29.png

 

You can specify the Group By so it restarts every time a new group comes up

RK3
6 - Meteoroid

Yes! Works perfectly. 

Thanks

Labels