Forum Discussion
pau11y
Jul 16, 2022Copper Contributor
Power Query, Creating a custom function to automate steps?
I am using Power Query to clean up some very messy data imported from a pdf. The pdf imports as several (300+) pages. Each page has its own query (... and I need to use the imported pages, not the im...
pau11y
Jul 16, 2022Copper Contributor
Additional Background on the pdf:
It's pretty diabolical. this 300+ pdf has a table on every page, of mostly, but not all the same size/shape. excel PQ naturally imports the PDF as each page is its own query, of course, and each table is it's own query. but not all tables are recognized and imported for some reason, but all pages are imported. so, thus far, I have based my transformation on the 300+ page queries.
at this point I have set of applied steps that I can manually copy into the advanced editor of any page query that transforms it to a useful table to later load to an excel worksheet.
I am trying to learn how to use a custom function to automate this manual copy-into-every-advanced-editor process.
(after which I will append all transformed queries to one giant table query, and load it to a worksheet. but the automated custom function is the current hurdle)
It's pretty diabolical. this 300+ pdf has a table on every page, of mostly, but not all the same size/shape. excel PQ naturally imports the PDF as each page is its own query, of course, and each table is it's own query. but not all tables are recognized and imported for some reason, but all pages are imported. so, thus far, I have based my transformation on the 300+ page queries.
at this point I have set of applied steps that I can manually copy into the advanced editor of any page query that transforms it to a useful table to later load to an excel worksheet.
I am trying to learn how to use a custom function to automate this manual copy-into-every-advanced-editor process.
(after which I will append all transformed queries to one giant table query, and load it to a worksheet. but the automated custom function is the current hurdle)