Hi guys,
I have a PDF table (attached) and I would like to extract it into Excel for further analysis. I used the PDF to Text and selected Alteryx Table as output option, but it doesn't give me the result that I want. I wonder if there is better way to extract PDF table information in Excel.
The ideal Excel template:
Related Scope | Current year 2012 | Public Sector | Private Sector | Others |
Overall Opinion | NI | S | NI | NI |
Control Environment | S | S | S | S |
Lorem ipsum Lorum ipsum Lorum ipsum | S | U | N/A | N/A |
@jerryjiang0413 interesting problem. I can see the issue. The PDF tool seems happy to scrape all the text from the pdf but it's facing issues with the table contents as they are actually images?
All the best,
BS