How to create a new column?

[LeoMessi]

Hello!

I want to add a new column in my dataset, using transaction date in DDMMYYYY format, and transform it into YYYY-0001 format. A sample is below:

Transaction Date	New Column
19/7/2022	2022-001
13/8/2021	2021-002
8/2/2020	2020-003

Thank you!

[Felipe_Ribeir0 · Accepted solution]

Hi @LeoMessi 

One way of doing this

[DavidSkaife · Accepted solution]

Hi @LeoMessi 

Here is a way of doing it using DateTime formula and a Record ID. Firstly create a record ID field in string format, specifying the length of the field, then parse the date into standard ISO format, format so it's only the year, and finally add the record ID to it:

[ShankerV]

Hi @LeoMessi 

One way of doing this!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @LeoMessi 

Input:

Output:

Shanker V

[DenisZ · Accepted solution]

Please see attached workflow, hope it helps

Feel free to mark it as solved if it solves the issue.

[ShankerV]

Hi @LeoMessi 

Step 1: Input

Step 2: Record ID tool

Step 3: Regex tool

Step 4:

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[LeoMessi]

Thank you, everyone!

Your respective solutions worked for me!!