Alteryx Designer Discussions

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

Extracting the Date from Text File

marlontalisvistar
9 - Comet

Hi,

 

I would like to ask if you could help me extract the date from a text file. Tried using the multi-formula tool but unsuccessful. See attached text file.

 

marlontalisvistar_0-1634470884899.png

 

3 REPLIES 3
Ar13f
9 - Comet

Dear @marlontalisvistar 

 

please find my workflow as below:

 

Solution 211017 835.png

 

This is what I can help, maybe there will be a better answer from friends who are more expert in this community. Because I'm also new to the world of alteryx.

marlontalisvistar
9 - Comet

Thanks @Ar13f . I tried used to add it in my workflow however, the result is not successful. Can you or someone help me arrange the date with the other first two columns? See my screenshot below.

 

marlontalisvistar_1-1634482403689.png

The correct output should somewhat look like this.

 

marlontalisvistar_2-1634482474292.png

Attaching my workflow.

marlontalisvistar
9 - Comet

Also, in addition, is it possible to add another column for Team Jovz for each Field_1

 

marlontalisvistar_0-1634483889777.png

Thanks,

 

Marlon

Labels