Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to transform the DateTime format for multi-column

AshCCC
5 - Atom

I'm trying to transform the String to DateTime Value, but seemed DateTime tool can do for one single column each time, how to do  for 5+ columns in one go????

6 REPLIES 6
flying008
15 - Aurora

Hi,@AshCCC 

 

you can use DateTimeParse function in Multi-Field Formula tool.

Qiu
21 - Polaris
21 - Polaris

@AshCCC 
Try a Transpose tool to bring the 5+ columns vertically.

Transpose.PNG

binuacs
21 - Polaris

@AshCCC another way of doing this with the Multi-Filed formula

 

binuacs_0-1652248112944.png

 

AshCCC
5 - Atom

thx!! let me try again!

AshCCC
5 - Atom

wow that's awesome as well, let me have a try anyway, thx!!

AshCCC
5 - Atom

Huge thx to you !!!!

Labels
Top Solution Authors