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 ,
Suggest method:
- Turn the transformation into a custom function
- (Parameter1, page)=> let Source = (Parameter1, Pdf.Tables(Parameter1, [Implementation="1.3"]), Page1 = Source{[Id=page]}[Data], Transformation step........ in Transformation stepApply the custom function by adding custom column (e.g. fxPage([Id]))
- If you get an error due to page variance, you can use "try otherwise" or skip error rows, depending on your situation.
- The last step is to combine the tables
Regards
KT
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