Forum Discussion

asdf123's avatar
asdf123
New Member
4 years ago
Solved

Multiple PDFs Different Tables

Hi,   I have a folder with multiple PDFs. The page lengths are all different. I'm trying to power query the last table in each PDF but each table number is different due to the page lengths/content...
Need Help
  • asdf123's avatar
    asdf123
    4 years ago

    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 

asdf123's avatar
asdf123
New Member
4 years ago

So i used List.Max but its showing the max table from all sheets. Is there a way to get it to show 0 if not the max and 1 if the max for each source name? From there i can filter by 1 and then open each data table i believe

 

 

asdf123's avatar
asdf123
New Member
4 years ago

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