In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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