Power query

Bassmansam · 13 Dec 2021 at 16:03

Hi

I am importing data from a PDF file into excel, there are 60 tables, on some tables the column names aren't being picked up correctly. Is there a way to change column names for every table in one go please?

Bassmansam · 13 Dec 2021 at 17:20

gpuerrilla said:
From Folder. Drop PDF(s) into the folder, in your PQ steps force a rename on the columns that seem problematic?

huh? Its just one pdf with 60 tables.

What i’m asking is, can i rename the columns in all tables at once?

Bassmansam · 13 Dec 2021 at 17:54

gpuerrilla said:
Are all the tables identical in layout?

they will be once i have done some cleaning up. It’s been inconsistent, for example on certain tables its decided to make more columns than others even though the pdf columns are consistent.

Bassmansam · 13 Dec 2021 at 18:08

gpuerrilla said:
Be handy if I could see the examples.

Is this a one off task and is it only available in PDF?

ah its for a new job i’ve started so i don’t feel comfortable sharing. I have to do this 4 times a year. I kind of know what i’m doing but its going to take a while to tidy up/ edit column names manually.
Thanks for your help