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

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 ?

alteryx issue.png

Datasets

Developer

Accepted answers

messi007

@Isaac_Juarez,

Please try with this version.

Regards,

CCM report.yxmd

All comments

afv2688

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

attached is the WF and the file.

Please see below:

1- Read the file without delimiter

2- below the workflow

Hope this helps,

Attached the workflow,

Regards,

CCM report.yxzp

Isaac_Juarez

hello messi007;

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

messi007

@Isaac_Juarez,

Please try with this version.

Regards,

CCM report.yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335