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.

Creating Count Sequence in a column

ll98
9 - Comet

 

 

 

Account IdNameCount OrderCount Order - Expected Result
45Orka11
45Orka21
45Balwing32
45Balwing42
45Cropsey53
45Alabama64
45Jersey75
45Jersey85

I created a multiple row sequence formula -- but its counting every row --If the name is the same - I just want to be counted once -- similar to what I'm looking in Column d.

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @ll98 ,

 

You can achieve that by configuring the multi-row formula tool as shown below

 

AngelosPachis_0-1608643839642.png

 

Hope that helps let me know if you have any questions

 

Regards,

 

Angelos

Emil_Kos
17 - Castor
17 - Castor

Hi @ll98,


I have created a solution for you.

 

Emil_Kos_0-1608644028667.png

I wasn't sure what the logic should be so I am checking both Account ID and Name. If they are exactly the same as the previous row then I identify them as the same group. 

 

Please mark my post a solution if this is helpful!

Labels