Provide Record ID per transactions chronologically

Hi,

I am trying to assign a chronological ID based on transactions with the same text in certain columns and a differing date column. I have multiple transactions that are identical (in certain columns) except for the date. I am trying to assign a 'First' 'Second' or 'Third' etc. column based on transactions with a date assigned. I have tried to figure out a way by a formula or by a record ID and cannot seem to figure it out. Please help and thank you in advance.

Workflow

Accepted answers

atcodedog05

Hi @hargquin

Only posibble way for getting words it to have lookup table and add the wording.

Here is how you can do it.

Workflow:

Hope this helps : )

word seq.yxmd

atcodedog05

Hi @hargquin

I have updated the workflow. With the help of data in this link i have updated wording to be till Hundredth.

Hope this helps : )

word seq.yxmd

All comments

clmc9601

Hi @hargquin,

Have you tried any of the following?

- CReW's GroupByRecordID

- Tile's configuration of Unique Value in your non-date columns

- Multi-Row Formula with [Row-1:field]+1 grouped by your non-date columns

I'm sure the community would be happy to mock up a workflow for you if you provide some sample data.

I hope this helps! If it does, please consider marking it a solution so others may find it.

apathetichell

I think @clmc9601 suggestions are all great - I'd go for the tile tool personally. You may have to sort by date first.

hargquin

I've attached a sample below. When the three columns are identical but the date is different, that's when the workflow needs to create a 'First', 'Second','Third', etc. for the transactions.

Alteryx example.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703