Alteryx Designer Desktop Discussions

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

Find and Replace question

RakeshPalla
5 - Atom

Hi... My input field is string which contains of text and date in different formats. To unify and compare the data against other file, i need my Field1 rows with different date formats to be consistent. Can you please direct me how to achieve this. 

 

Field1Output
Principal FSMPrincipal FSM
2020-01-1001 Oct 2020
15/10/202015 Oct 2020
1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor

Hi @RakeshPalla I mocked up a workflow let me know what you think?

 

Find_Replace_061120202.JPG

Labels