How to align columns in text format

Question

Hi, I have a dataset that is in text format but once I load it in alteryx the alignment becomes pretty messy. Is there a proper way to load text data in alteryx

attached the sheet,

Expected output:

I always have to pick the first one from the text, for example below 1 st record (9856452EX)Apple was the first so I picked the apple and not mango.

And also I have picked the quantity of apple

Code of the productProductQuantityTotal QuantityCurrency 9856452EXApple525USD956874FXMango525USD

Test.txt

AkimasaKajitani · Answer

Hi @Sshasnk

Here is the solution for you.

Result:

Your data is not simple, so you have to parse the data.

1.I used the RegEx tool to parse the each data.
2.I used the Multi-Row formula tool to separate the each record.
3.I used the Transform and CrossTab tool to put parsed data into each record.

Please refer attached Workflow.

Parse_data_sample_AK.yxzp

Sshasnk · Answer

@PhilipMannering updated

philipmannering · Answer

Difficult to say @Sshasnk  without seeing the file. It shouldn't come in misaligned! I don't suppose you share any of the data or at least a screenshot of the txt file?