Parsing Tables using Python within Alteryx

NeilFisk

I have a workflow that I developed outside of Alteryx that parses all the tables in a PDF file.  I wanted to incorporate that workflow into Alteryx so I can then do downstream cleansing.  Unfortunately, I'm having challenges getting it to work.  The error I am getting is that no such file or directory exists, so I'm thinking I'm missing some syntax I'm not familiar with.  

Attached is the workflow (the path would have to be changed for someone else to run) as well as the PDF file.

Any assistance would be greatly appreciated.

Neil

PDF Table Parse.yxmd

FAA-2017-1206-0009_attachment_2.pdf

philipmannering

As @apathetichell mentions, the key here is the `.iloc[0,0]`. You also need to make sure that Java is in your PATH environment variable (though assume this is done if it was working outside of Alteryx). You don't need to do anything with the forward/back slashes. Here's the full code, I used to get it to work,

import pandas as pd
from ayx import Alteryx
from tabula.io import read_pdf

# read in filepath
FullPath = Alteryx.read("#1").iloc[0,0]

# read in the PDF and create a dataframe list
dfs = read_pdf(FullPath, pages='all')

# combine dataframes within list to one complete file   
df_tables = pd.concat(dfs) 

# and then send it to one of the output anchors
Alteryx.write(df_tables, 1)