Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Joining field to create a date

Jaloy_1973
7 - Meteor

Hi Community,

 

I have 3 V_String fields, corresponding to the day, month and year. of a dataset.

I would like to concatenate them to transform then into a date with the DateTime tool.

I assume it must be easy but I can't figure out how to join the three fields?

 

Thanks a lot!!!

 

Jordi

 

 

 

4 REPLIES 4
binuacs
20 - Arcturus

@Jaloy_1973 One way of doing this

image.png

Manoj_k
8 - Asteroid

I tried a different method where you concatenate the string field and then convert them to date using date time tool 

Jaloy_1973
7 - Meteor

Really appreciated.

It worked perfectly.

 

Jordi

Jaloy_1973
7 - Meteor

Many thanks, it worked too.

 

Jordi

Labels