Reading 5 rows from 108 page PDF

Hi There,

I have recently got hold of the Alteryx BI Suite. I am playing with the tool to do a POC on using PDF as my Source. I am attaching a sample PDF that I have. From this PDF I need to read just 5 rows and load them to an excel. I was trying to use Image Template and then convert it to text and then finally load it to an excel. I have seen that the markers on PDF change with every, I need to to annotations always. The process is everyday a new file comes, I need to ready exactly those 5 rows and load data to an excel. Can anyone guide me on this? I also tried another way of converting the file to rows & Columns but my workflow has been running from 1 Hour. Attaching my PDF & both workflows.

Note I just want to read page 1, there are 5 rows highlighted in yellow. I need those 5 rows along with last row (Total By Business) in a single excel.

I am new to alteryx and would like to explore more, hope I get a solution soon.

Thanks in Advance

New Workflow2.yxmd

Trial_test_POC.yxmd

FY21 Daily Revenue May - 10 of 25 days (40%).pdf

Text Mining

Accepted answers

All comments

hellyars

I also have the Intel Suite. I have not downloaded your workflows. But, I did look at the the PDF. I have found the new tools to be less than optimal if your target text within the PDF shifts (even just a bit) and performance is not exactly speedy.

Do you have Acrobat Pro DC? And, have you tried copy / paste (keep formatting) from the PDF to Excel. You could also try exporting from Acrobat to Excel. It might work, and it could be faster.

Mansi3

Hey Hellyars,

Thank you for taking time and responding. Actually I do not have Acrobat Pro DC also I want to automate the entire process. Like everyday I will be getting new PDF so I need to read it everyday, convert to text then use it to match with the results of a Stored Procedure from SQL.

It would be a good Use Case for us to show Capabilities of Alteryx. Would be good if we could read the PDF without annotations.

Thanks

Mansi C.

royhamptonTD

I'm testing a solution I developed with the Image reader and running into the exact problem you flagged - "I have found the new tools to be less than optimal if your target text within the PDF shifts (even just a bit) and performance is not exactly speedy."

The position of the relevant content that I want to extract from my PDF input shifts for different months, which means if I use the annotation method it picks up the wrong data from the PDF. Is there a way to dynamically select content from PDFs without using annotations?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703