Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
I am looking to get support from the Alteryx Community. I have text report from our oracle database that I want parse into columns that should look like this:
However, when I use text to columns to tool, it is just messy.
It seems like the regex tool would be the way to go, but I wasn't too sure.
Can anyone help me on how I should tackle this?
I have added the sample txt file as well. Please let me know if you have any questions, thank you.
Solved! Go to Solution.
Hi @imadorkous, when inserting the file in Alteryx, select the option to read it as fixed width text file. Then you just need to click where each field begins as below:
