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
I got an error on Id=page and unsure on try otherwise/skip error rows. What custom column formula could i use to filter each source.name to their max table names? I think Table.Max might work but not sure how to incorporate.
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
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