Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
14 - Magnetar

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
Top Solution Authors