PowerQuery - Table Merge Query
Hey all,
Quick question when it comes to merging tables in PowerQuery...
My current process is to merge table1 with table 2, then table2 with table 3 and so on. Would this be the best practice or is it better to merge table1 with table0, then table 2 with table0, table3 with table0, etc. I'm self taught with PQ and couldn't find a definitive answer online to this question.
Any help on clearing this up would be appreciated.
It may be easier for someone to give an opinion if we could see samples of the tables and a sample of the desired output.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I can't provide exact samples from PQ, but I'll attach visual representations of the two scenarios - I'm asking which of these two scenarios is generally considered more efficient when it comes to a device processing the data/queries.
Attachment 886475
Attachment 886476
Selecting either attachment in post #3 results in the following error message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
Please utilize the information in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks