Date Formatting and creating new column (concat)

[sriniprad08]

Hi Team,

Hope you are well.

I need help.

I need to create a new column based on three exiting column. The first step is to format the date column and then concatenate.

Please let me know,

Thanks,

Sri

[ShankerV]

Hi @sriniprad08 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @sriniprad08 

Step 1: Input

Step 2: 

Step 3:

left(RIGHT([Year], 7),2)

Step 4:

[COM]+"."+[Year]+"."+[CNO]

[COM]+"-"+[Year]+"."+[CNO]

Many thanks

Shanker V

[DanielG · Accepted solution]

@sriniprad08 this one uses RegEx to get the Year out.  No need for the intermediate step either.

[DanielG]

This also assumes your date field structure is consistent in your full data set.  I am guessing it would be seeing as it included the lead zeros on month, day and the time element.  😊

[sriniprad08]

Hi @ShankerV ,

Looks great. Thank you. Can you please share the workflow?

Thanks,

Sri

[sriniprad08]

Hi @DanielG ,

Great thanks. As per the requirement i need to have two separate column as output one with "." and other with "-". But currently your solution have both in same column. how can i modify that?

[DanielG]

@sriniprad08  Just copy the formula for the 1 column into another and swap out the punctuation to give you both output fields

[ShankerV]

Hi @sriniprad08 

Sorry, couldn't save the workflow as error is prompted.

Could you please replicate my workflow as I have shared all the steps. 

Many thanks

Shanker V

[DanielG]