Hi Experts,
I have 30 tables import from Word document save as Web Page (HTML) format to Power Query. I import this tables using "From Web" icon. Is it possible, to do multiple tasks on this tables like remove rowes or set up first rowes as column headers. I would like to select all tables and like in excel sheets make changes for all tables.
Thanks for help !
Is your source data stored in 30 different files?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
No all the tables are in one word file.
Post a sample of your Word file, and your existing (single table) query.
Please Login or Register to view this content.
I get an error message when I try to attach a file
Last edited by wrybel; 07-20-2017 at 09:11 AM.
What does your output look like - are you trying to combine the tables?
Yes using append button.
Okay - first, write a function which performs the table transformation:
Please Login or Register to view this content.
Then you can apply this function to each data table in the html file, and expand:
Please Login or Register to view this content.
I wonder if this helped?!
Unfortunately no. I open a blank query and paste a function. Then open another blank query and paste your second code and then I receive this errorPlease Login or Register to view this content.
Did you name the first function appropriately (e.g. "fntransformTable" ) ?
Ok, it works. Thansk for help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks