+ Reply to Thread
Results 1 to 4 of 4

Excel Power Query - Match one column but not the other

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    6

    Excel Power Query - Match one column but not the other

    In Excel Power Query I am trying to match two tables where one column should match (i.e. GUID), but the other shouldn't (i.e. Value) so that I end up with only the different values from the join/merge.

    So the equivalent in SQL would be this:
    Please Login or Register  to view this content.
    Is this possible at all or will I need to use some kind of INDEX MATCH or VBA code to achieve this?

    Attached you will find an example file with the result (green header) that I expect.
    Attached Files Attached Files
    Last edited by naj1990; 03-11-2021 at 05:50 AM. Reason: Adds sample file

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,877

    Re: Excel Power Query - Match one column but not the other

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-19-2021
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    6

    Re: Excel Power Query - Match one column but not the other

    Hi Alan, I attached an example file of what I would like to achieve.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Excel Power Query - Match one column but not the other

    Just do a join on GUID, add a column to return true if the values match, false otherwise then filter out the true values.
    Rory

+ 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. [SOLVED] Power Query/Power Pivot Conditional Column creation & chart
    By mz_h in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2020, 06:07 PM
  2. [SOLVED] Excel and power query - Add column with filename?
    By jfca283 in forum Excel General
    Replies: 4
    Last Post: 12-06-2020, 09:19 AM
  3. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  4. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  5. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  6. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  7. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM

Tags for this Thread

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