How to get a running count on a column

[xqccc]

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 solution]

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 solution]

@xqccc find the workflow attached
Mark done if solved.

[flying008 · Accepted solution]

Hi, @xqccc 

FYI.

[Qiu · Accepted solution]

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

[aatalai · Accepted solution]

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

[nagakavyasri · Accepted solution]

@xqccc One way of doing this:

[xqccc]

Thanks everyone! I can't use the sort tool. I think the macro solution works for me. Really appreciate all your help on this topic!