Hello everyone,
Recently I had to work with pdf files. To work with them on alteryx, I use converter tool to convert multiple pdf files in to one and than I convert that ''one'' pdf file to excel worksheet to create an input for the Alteryx. PDF pages turns in to different sheets. ie pdf page 2 becomes Sheet2.
What I want to do is, find specific name and corresponding value of it in each spreadsheet and than filter them.
Problem is, since I converted these excel files from pdf every sheet has different layout. Column and row numbers are not matching and some sheets does not have the value I am searching. I try to use the workflow below;
-select input excel and list spreadsheet names
-use dynamic tool and link it to the excel file that I want to extract data
-rest is filtering
However, when I run the flow, I get Sheet#" has a different number of fields than the 1st file in the set and will be skipped. I believe it is because column and row numbers are not matching and table layouts are different.
Is there way to find specific value in different type of excel sheets in Alteryx?
