Alteryx Designer Desktop Discussions

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

Convert PDF data to Excel

SomuGS
8 - Asteroid

Hi,

 

I looking for means to convert large number of PDF(s) (multiple/different formats) to excel data. I'm wondering if there is solution for this use case?

 

I tied to use solution in this page - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Read-PDF-and-Extract-Data-in-T...

but it did not work for me.

 

Any help on this is appreciated!

 

Thanks,

BSomeshe

1 REPLY 1
cjaneczko
13 - Pulsar

Intelligence Suite or PDF Input tool would be the only two methods I am aware of. How many different formats are you talking about? Best case would be to group all the ones that are the same and use the PDF input for each grouping. Then youll need to use RegEx to parse the data into the appropriate fields. Join the data once its parsed, then you can output however you like.

Labels
Top Solution Authors