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
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
@sriniprad08 this one uses RegEx to get the Year out. No need for the intermediate step either.
One way of doing this.
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. 😊
Hi @ShankerV ,
Looks great. Thank you. Can you please share the workflow?
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?
@sriniprad08 Just copy the formula for the 1 column into another and swap out the punctuation to give you both output fields
Thank you. The year part is not coming.
Plesae find attached the full column of the year.
@sriniprad08 -- hi sorry. had a meeting that side-tracked me... 😀 I assume Alteryx is taking it from Excel and automatically making it a date then. If so, try this:
If anyone else is reading this and wants to write slightly more efficient RegEx, it would be greatly appreciated. Mine works, and I am getting better at it but am still a bit of a hack. Haha.
