Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Auto count increment based on data from another column

KNguyen
7 - Meteor

How do I increment count based on a column?

 

Sample

Col ACol B
70000207111113
70000218111012
70000221111012
70000232111012
70000234111012
70000239111012
70000240111012
70000242111012
70000245111012
70000245504083

 

End Result - Count increment based on column A above. 

NumberCol ACol B
170000207111113
170000218111012
170000221111012
170000232111012
170000234111012
170000239111012
170000240111012
170000242111012
170000245111012
270000245504083

 

3 REPLIES 3
mceleavey
17 - Castor
17 - Castor

Hi @KNguyen ,

 

I did this simply by adding a number column, and using the Running Total tool.

You can also do it with a multi-row but this was means you don't need to write a formula.

 

mceleavey_0-1648153492718.png

mceleavey_1-1648153504792.png

 

 

I hope this helps,

 

M.

 

 



Bulien

mceleavey
17 - Castor
17 - Castor

@KNguyen 

and here it is with the multi-row:

 

mceleavey_0-1648153608410.png

mceleavey_1-1648153632878.png

 

M.

 



Bulien

KNguyen
7 - Meteor

Oh this is awesome! The multi-row tool. I wasn't able to get the running total to work. But got the multi-row tool to work. The running total, for some reason the create running total section doesn't show the number field i created. 

 

KNguyen_0-1648155143368.png

 

Labels