Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
8 - Asteroid

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
21 - Polaris

@Jaloy_1973 One way of doing this

image.png

Manoj_k
9 - Comet

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

Jaloy_1973
8 - Asteroid

Really appreciated.

It worked perfectly.

 

Jordi

Jaloy_1973
8 - Asteroid

Many thanks, it worked too.

 

Jordi

Labels
Top Solution Authors