Data extraction from PDF files

Question

I have an image template for a table, In certain files, this table appears on a single page, which allows me to extract the data correctly. However, the table spans multiple pages in other files, causing extraction issues. I want to extract Table 1: Key metrics data from the attached files. Can someone please give me the workflow and advise how I can handle multi-page tables in Alteryx, possibly using computer vision tools?

2.pdf

1.pdf

Garrett_Stoker · Accepted Answer

Forgive me if this is a dumb question, but have you tried using the PDF to Text tool? You can bring it in using that tool, use a Formula tool to determine which lines are relevant, and then filter out what you don't need. I would try and put it together but I don't currently have a license for AIS. 🙃

It's detailed in this community post from last year.