Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx Academy MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎11-06-2020 08:42 AM

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
Labels:
Reply
0 Likes
1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor
‎11-06-2020 08:47 AM

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

 

Find_Replace_061120202.JPG

Find_Replace_06112020.yxmd
Reply
Labels
Top Solution Authors
View All