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