Alteryx Designer Discussions

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

parsing a pesky txt file

CorCor
8 - Asteroid

Hello - 

 

I DID find some help in the community - and tried a few solutions - but none of them worked quite right.

I am sure I need to use the "text to columns" tools a couple of times....but cant work it out.

Trying to put this into a table (obvs)

 

Is it the file itself and not having clean delimiters?

 

Thanks!

3 REPLIES 3
Emil_Kos
16 - Nebula

Hi @CorCor,


For me it works:

 

Emil_Kos_0-1611874562972.png

 

Output:

 

Emil_Kos_1-1611874569546.png

 

Please check my workflow maybe you have a different configuration.

 

If this was helpful for you please mark my post as a solution!

 

CorCor
8 - Asteroid

I guess I am missing something.  Cause when I opened what you attached - I only got this.

CorCor_0-1611939577515.png

 

CorCor
8 - Asteroid

Nevermind.  It has to do with how I imported to begin with.  I get it now.

Thanks

Labels