Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Joining field to create a date

Jaloy_1973
メテオール

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件の返信4
binuacs
アルクトゥルス

@Jaloy_1973 One way of doing this

image.png

Manoj_k
コメット

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

Jaloy_1973
メテオール

Really appreciated.

It worked perfectly.

 

Jordi

Jaloy_1973
メテオール

Many thanks, it worked too.

 

Jordi

ラベル