text file to be converted to desired Output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much....
