text file to be converted to desired Output

[ferha_jafri]

Hello Experts, I have a requirement where I have a input in txt file and want to convert it in a particular output. I am attaching the txt as input and xlsx as output.

[mbarone]

Check out (and bookmark!) the Tool Mastery Index which will give you great tips on various tools.  Another great resource to help you on your Alteryx journey is the Alteryx Academy .  Lots of free resources/videos/tutorials/use cases, etc.

Hint for your specific question today:  You'll want to review the Input Data Tool and Output Data Tool from that  Tool Mastery Index.

[mceleavey · Accepted solution]

Hi @ferha_jafri ,

this is complex as it requires taking a quite awful format and using brute force to make it fit.

I've built it for you, but this will only work if the format coming in is consistent.

This splits it into sections, uses a few pivot tools and a bit of regex to get it to work.

My output is exact, but like I said, only if it's consistent.

I hope this helps,

M.

[ferha_jafri]

Thank you so much....