+ Reply to Thread
Results 1 to 7 of 7

Lookup and transfer data from one query to another query

  1. #1
    Registered User
    Join Date
    10-10-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    58

    Lookup and transfer data from one query to another query

    Hi,
    Please help on the below issue.

    In power Query, I have two workbook queries and I need to transfer the related match column data from one query to another query data.

    How to insert the formula column in the query for Lookup.

    Thank u.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Lookup and transfer data from one query to another query

    Use the "Merge Queries" function, and choose the matching column in both tables.

    The M code will look something like:
    Please Login or Register  to view this content.
    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...

  3. #3
    Registered User
    Join Date
    10-10-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: Lookup and transfer data from one query to another query

    Dear Mr. Olly,
    Thanks for your information.
    But I did not find my output. I hereby attaching the files what I need with detailing. Can you please convert that requirement in power query in excel file.
    Thank you.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-10-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: Lookup and transfer data from one query to another query

    Hi,
    Can I get the solution for the above message along with attachments.

  5. #5
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Lookup and transfer data from one query to another query

    Try this:
    Please Login or Register  to view this content.
    You may need to change the data type of [RES No.] in query "Append1":
    Please Login or Register  to view this content.

    The logic works in a slightly diffferent way to your PDF - we unpivot first, then look up the values returned to find the Code - then we can simply do a count of rows, with the appropriate grouping.

  6. #6
    Registered User
    Join Date
    10-10-2009
    Location
    UAE
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: Lookup and transfer data from one query to another query

    Hi,
    Its working and I got it.
    Thank u very much.

  7. #7
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Lookup and transfer data from one query to another query

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SQL Query loading in MS Query but not importing data to excel
    By sharper1989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2016, 09:52 AM
  2. [SOLVED] SQL Query loading in MS Query but not importing data to excel
    By sharper1989 in forum Access Tables & Databases
    Replies: 0
    Last Post: 05-19-2016, 09:31 AM
  3. Transfer of data from one sheet to other after web query
    By sabha in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-18-2015, 06:10 AM
  4. Lookup Data Query
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-18-2014, 01:00 PM
  5. Replies: 8
    Last Post: 08-06-2010, 07:27 AM
  6. [SOLVED] Importing Data via Web Query - Can values be passed to query?
    By jgalenski@charter.net in forum Excel General
    Replies: 5
    Last Post: 05-09-2006, 01:25 PM
  7. Database Query-a query that reads data from MS Access
    By Osmar Mateus in forum Excel General
    Replies: 4
    Last Post: 01-29-2006, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1