how to count record

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

Workflow

Accepted answers

Hi @luo ,

Here is a workflow for the task.

Output as expected

Hope this helps : )

Please mark post as solution if it helps.

Record Count.yxmd

All comments

Hi @luo ,

Here is a workflow for the task.

Output as expected

Hope this helps : )

Please mark post as solution if it helps.

Record Count.yxmd

Hi, @atcodedog05

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

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335