Parse and tabulate pdf file to excel

Pankhudri20

Hello,

I have a telephone bill pdf document from which I need to extract only the call details table to an excel file.

Is there a way to do this in Alteryx without using python?

Datasets

Developer Tools

Output

Python

Parse

Accepted answers

echuong1

There are a couple of PDF reading tools available for download on the Public Gallery. They leverage python/R in the background, but are user-friendly.

https://gallery.alteryx.com/#!app/PDF-Input/5b685aff0462d710907f7a3b

https://gallery.alteryx.com/#!app/PDF-Input--Text-and-Image-/5be5ec8d0462d71ffce6deaa

You could also use the PDF capabilities in the Intelligence Suite (which may be better suited depending on the format of your PDF), but those are an additional license to Designer.

https://www.alteryx.com/products/alteryx-platform/intelligence-suite

pedrodrfaria

Hi @Pankhudri20

You will need to download the PDF Input tool and install the R Package for "pdftools". I see that @echuong1 provided you with the link,

To complement what was said, you will need to use this workflow to install the R package that you will need.

Here is a video you can watch to help you set it up.

https://www.youtube.com/watch?v=0aM9YqC1Uuo&ab_channel=NathanPatrickTaylor

Let us know if you need any help.

Pedro.

Install+R+Packages.yxzp

All comments

echuong1

There are a couple of PDF reading tools available for download on the Public Gallery. They leverage python/R in the background, but are user-friendly.

https://gallery.alteryx.com/#!app/PDF-Input/5b685aff0462d710907f7a3b

https://gallery.alteryx.com/#!app/PDF-Input--Text-and-Image-/5be5ec8d0462d71ffce6deaa

You could also use the PDF capabilities in the Intelligence Suite (which may be better suited depending on the format of your PDF), but those are an additional license to Designer.