How to get a running count on a column

Question

For example, I have col A like below and I would like to get the count column.

Col A   Count

A             1
B             1
C             1
D             1
A             2
E             1
B             2
F             1
D             2

A             3

In excel, the count column can be get by formula "=countif(A:A,A1) and then copy this formula down. How can I achieve the same result in Alteryx without changing the sequence of the data(not using sort). Thanks!

alexnajm · Accepted Answer

Have you looked at the Running Total tool? That’s your best option - just make sure to create a column of 1 for each row so you can sum up.

if you need to keep the order, add a record id tool beforehand, do what you need, then sort your data back on that record id column

Raj · Accepted Answer

@xqccc find the workflow attached
Mark done if solved.

flying008 · Accepted Answer

Hi, @xqccc

FYI.

Qiu · Accepted Answer

@xqccc 
If you really hate the Sorting tool😁, we can use a Batch Macro as below.

aatalai · Accepted Answer

@xqccc this should work, uses similar logic to @flying008 but uses multi row rather than tile tool

nagakavyasri · Accepted Answer

@xqccc One way of doing this: