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?

[echuong1 · Accepted solution]

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 · Accepted solution]

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.

[Pankhudri20]

Hello,

Thank you @echuong1  @pedrodrfaria  for providing me with these tools.

Regards,

Pankhudri

[Pankhudri20]

Hello,

I am running the PDF Input package as mentioned but I am getting the error 'can't find plugin "AlteryxRPluginEngine".dII'.

Can you tell me how to resolve this?

Thank you

Pankhudri

[pedrodrfaria]

@Pankhudri20 Can you confirm that you have the R tools installed in your Designer? 

If not, you need to install it. You can install it from the link below:

https://gallery.alteryx.com/?ref=downloads#!account 

Sign in, go to the previous versions of Alteryx Designer and download the predictive tools.

Thanks,

Pedro.

[Pankhudri20]

Hello,

Thank you for your response!

I am trying to install but it is asking for administrator privileges.

How should I do that?

I do have a licensed Alteryx version.

Regards,

Pankhudri Agrawal

[pedrodrfaria]

Hi @Pankhudri20 

You had the option to download the non admin or the admin version. Go back and download the non admin version if you dont have admin privileges.

[Pankhudri20]

Hello

Thank you for your response.

Can you tell me which version should I install for Predictive tools and non admin version?

Do both need to be the same version ?

Regards,

Pankhudri

[echuong1]

You can download the installer for the predictive tools at http://downloads.alteryx.com/.

The installer must match the version of Designer you have - version number and type. You can find this information by going to Help > About on Designer.

Once you have that information, go to Designer > [version number you have]. You can download the appropriate installer there, which in your case would be non-admin.