• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member
  • Login

Loading query to source sheet|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Loading query to source sheet|Power Query|Excel Forum|My Online Training Hub

office scripts course

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumPower QueryLoading query to source sheet
sp_PrintTopic sp_TopicIcon
Loading query to source sheet
Avatar
Steven Strenkowski

Active Member
Members
Level 0
Forum Posts: 5
Member Since:
April 8, 2021
sp_UserOfflineSmall Offline
1
April 8, 2021 - 7:14 am
sp_Permalink sp_Print

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.

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1548
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
April 8, 2021 - 10:10 am
sp_Permalink sp_Print

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

Avatar
Steven Strenkowski

Active Member
Members
Level 0
Forum Posts: 5
Member Since:
April 8, 2021
sp_UserOfflineSmall Offline
3
April 9, 2021 - 12:29 am
sp_Permalink sp_Print sp_EditHistory

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.

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1548
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
4
April 9, 2021 - 5:08 pm
sp_Permalink sp_Print

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

Avatar
Steven Strenkowski

Active Member
Members
Level 0
Forum Posts: 5
Member Since:
April 8, 2021
sp_UserOfflineSmall Offline
5
April 15, 2021 - 1:09 am
sp_Permalink sp_Print

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).worksheet-Code-Descriptions.JPGImage Enlarger

Merge2-power-query.JPGImage Enlarger
Data-Merge-Screen-1.JPGImage Enlarger

 

I hope this makes more sense.

sp_PlupAttachments Attachments
  • sp_PlupImage worksheet-Code-Descriptions.JPG (169 KB)
  • sp_PlupImage Merge2-power-query.JPG (71 KB)
  • sp_PlupImage Data-Merge-Screen-1.JPG (81 KB)
Avatar
Steven Strenkowski

Active Member
Members
Level 0
Forum Posts: 5
Member Since:
April 8, 2021
sp_UserOfflineSmall Offline
6
April 15, 2021 - 4:38 am
sp_Permalink sp_Print

Hello Philip,

You can ignore my last post - I just decided to change all my source data to the new merge and left it at that.

Thanks for your help and understanding.

Best regards.

Steve

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1548
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
7
April 19, 2021 - 8:47 am
sp_Permalink sp_Print

No problem.  Glad you got it sorted out.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Cindy Walawander, tre lewis, Earl Tuckman, Rob Starren, Leigh Thomas
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Mohamed Touahria
Sheila McCall
Nicholas Montano
John Babcock
QSolutions Group
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28549

 

Member Stats:
Guest Posters: 49
Members: 32803
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel Office Scripts
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate
  • Sponsor Our Newsletter

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.