Forum Discussion
Multiple PDFs Different Tables
Update: I used Group By to group the max table names by each source name as I needed. But the table numbers are just text and i need to get the data from each now. Any ideas?
Edit: I went to the Transform Sample File and sorted the table IDs from highest to lowest and then removed all but the top row. This applied the transform to the other sheets so it seems to be working!Thanks
Impactful IndividualHi asdf123 ,
The provided information is not sufficient to provide much guidance as every PDF files are different.
One suggestion if you're trying to transform the tables from PDF which doesn't come in equal rows and columns. You can try "page" instead of "table". Pick a small sample and transform it, then turn it into a custom function and apply it to all pages. You might need to refine the transformation steps repeatedly until you reach your desired outcome.
Regards
KT
So if I try page, I get an error for PDFs that arent the same page lengths. As I need the last page in each PDF. If my sample is 6 pages and another is 4, it gives an error as it can't pull page 6 from 4 pages. What function would you suggest that could do this? Heres the current function:
Ok so I think I'm getting closer here.. I tried transforming all the sheets and now need to somehow filter the last table on each page (likely by adding a conditional column to do this). Any ideas?