Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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