Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to arrange data from a row to columns with different string values?

Isaac_Juarez
7 - Meteor

Hello Alteryx developers!

 

I am working on a WF to arrange a TXT file out of a dimensional measurement machine. as the output file gives me different measurements by axis the file has huge data in a single row.

 

 Anyone know how to to arrange the data ? 

5 REPLIES 5
afv2688
16 - Nebula
16 - Nebula

Hello @Isaac_Juarez ,

 

Could you share a few lines please? It would help me to get your results. Just the ones that are visible on the image are ok 🙂

 

Regards

Isaac_Juarez
7 - Meteor

attached is the WF and the file. 

messi007
15 - Aurora
15 - Aurora

@Isaac_Juarez,

 

Please see below:

 

1- Read the file without delimiter

 

messi007_1-1612465558175.png

 

2- below the workflow

 

messi007_0-1612465470034.png

 

Hope this helps,

 

Attached the workflow,

 

Regards,

Isaac_Juarez
7 - Meteor

hello messi007;

 

What version are you using? I have the 2020.1 and I cant open it. 

messi007
15 - Aurora
15 - Aurora

@Isaac_Juarez,

 

Please try with this version.

 

Regards,

Labels
Top Solution Authors