In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Split columns fixed width

AlteryxDummy01
5 - Atom

Hi, I have been trying to use a PDF input converter which works quite well. Although, all the text in the PDF gets converted into one column of Alteryx. I was trying to use different delimiters by using split text to column, but none of them work. Therefore, I think it has to do with the Fixed Width. I am not sure how to use this function if I don't have an .txt input. 

 

 

AlteryxDummy01_0-1645531875267.png

 

Does anyone have a good solution for this?

1 REPLY 1
gabrielvilella
14 - Magnetar

You can save it as a text file and then read it using dynamic input. Or you can use RegEx. Another option is the one from this post https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Fixed-Width-Delimiter/td-p/772173 

Labels
Top Solution Authors