Log In
Register
Home
Active Member
April 8, 2021
Offline
I have a data table that is saved in a worksheet the result of a power query against an xls documents in an outside folder. I have loaded a code description and category table into my exisiting xls document.
Using power query on the worksheet and the category table - i merged the two queries and applied the description and category to a new merge1 query.
I would like the new columns to reside in my original query worksheet rather than create a new one. Is this possible or do I have to create a new merge1query.
I am a beginner and I am trying to learn on my own and I appreciate any advice you can provide.
Thanks in advance.
October 5, 2010
Offline
Hi Steven,
You can load the query results to any sheet you like. When you click on Close & Load To you can choose to load to an Existing worksheet.
However, having your source table and your query result table on the same sheet can cause issues if the source table grows in size and overlaps the query result. If the number of columns stays the same, you can have both tables side by side, with a column of space between them.
Regards
Phil
Active Member
April 8, 2021
Offline
So, I am confused, and I apologize in advance.
When I merge my power query table result with another table to add two descriptive columns "code description" and "code categories" at the end of my original power query. I need to create a new Query result or spreadsheet and I can't simply merge and replace. If that is the case, if I am adding descriptions from several different codes and i need to do 3 merges, I have to create new data tables (Spreadsheets) for each and then only keep the last merged dataset for my pivot tables. So, every time I do a merge of two queries, i will have to update all my pivot table sources.
Does that question make sense? Am I being stupid to think I can just keep merging and replacing my original query. I already built my pivot tables and I am now adding descriptions via merges and I am trying to avoid changing the sources for all the pivot tables - unless there is an easy way to change the source across all pivot tables globally?
When I goto the new data sheet and hit Load to: the "Select where the data should be loaded" section is greyed out and not accessible. See my screen shot attachment.
When you do a merge I don't see an option function to load over the current power query
I am very new (a couple of days), so forgive me if this is just a stupid question.
Thanks in advance.
October 5, 2010
Offline
Hi Steven,
It's hard to understand what you are trying to do without seeing your files.
Can you please attach some sample files including the queries.
regards
Phil
Active Member
April 8, 2021
Offline
Hi Philip,
I apologize for the confusion and I am sure a little frustration with my question.
If I can simplify my question - can I do a merge and have the data placed in the original worksheet or do I have to create a new merge spreadsheet everytime.
In the screenshots attached - I have a Data table (spreadsheet) and a Code Descriptions Tab
I merge them and the merge result (Merge2) is now a new dataset.
------
Can I merge the data table (spreadsheet) and the code description tab and have the result end up being in the original data table (spreadsheet)? If not, how do I create a new merge data table after the merge is processed?
Screen shots attached.
I also attached my xls spreadsheet - the two tabs I am merging our Data table (status Code) and Code descriptions (Code) and then I would like the merge to end up in the Data Table so I don't have to change the source of all my pivots. I am adding two additional description columns (description and category from the code description tab).
I hope this makes more sense.
1 Guest(s)
