Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How do I change String to DateTime for multiple columns at once?

nhubaorai
5 - Atom

Hello,

 

I have 3 columns Settled_Date, Invoice_Date, Due_Date with different values like the image attached below. I need to convert to DateTime data type. How do I do this? I tried DateTime parse and Multiple Join, it worked but it would give me 3 icons and would not join those icons. Thank you for your help!

payment2.png

7 REPLIES 7
ChrisTX
16 - Nebula
16 - Nebula

Use the Multi-Field Formula tool.

 

What do you mean by "it would give me 3 icons and would not join those icons"?  Can you post a sample workflow?

 

Chris

IraWatt
17 - Castor
17 - Castor

Hey @nhubaorai, could you give a sample dataset?

nhubaorai
5 - Atom

Thank you for your reply. Here is my sample workflow. Three DateTime Convert icons.  When I do Join Multiple, it gives me an error.

workflow.png

nhubaorai
5 - Atom

Thank you for your reply. Here is my sample dataset.

IraWatt
17 - Castor
17 - Castor

Hey @nhubaorai,

Does this approach work for you?

IraWatt_0-1655923416580.png

 

nhubaorai
5 - Atom

Works perfectly. Thank you so much!

IraWatt
17 - Castor
17 - Castor

Great ! no worries @nhubaorai 😄

Labels
Top Solution Authors