how to count record

[luo]

Hi,

I have a datatable that look like:

No	Amount	Memo	Date
1	213		20200901
1	1234		20200901
1	4124		20200901
2	1438		20200902
2	157		20200902
3	1237		20200910
3	1238		20200910

and I want to transfer to 

No	Amount	Memo	Date	SubNo.
1	213		20200901	0
1	1234		20200901	1
1	4124		20200901	2
2	1438		20200902	0
2	157		20200902	1
3	1237		20200910	0
3	1238		20200910	1

Is there a way to do that? Thank you

[atcodedog05 · Accepted solution]

Hi @luo ,

Here is a workflow for the task.

Output as expected

Hope this helps : )

Please mark post as solution if it helps.

[luo]

Hi, @atcodedog05 

It's acctually not count by date. Is there another way that do not use date?

[atcodedog05]

Hi @luo 

you can use "No" column too, to get the desired output.

You need to groupon a certain column get this desired output.

I dont see anyother way to get the expected output.