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 product | Product | Quantity | Total Quantity | Currency |
9856452EX | Apple | 5 | 25 | USD |
956874FX | Mango | 5 | 25 | USD |
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?
@PhilipMannering updated
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.