Results 1 to 5 of 5

Thread: Table.NestedJoin if Statement

  1. #1
    Acolyte jilbobagins's Avatar
    Join Date
    Apr 2019
    Posts
    52
    Articles
    0
    Excel Version
    2016

    Table.NestedJoin if Statement



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Howdi,

    Does anyone know if its possible to Merge 2 Tables together where the first table has two possible columns to join from and the second table only has one??

    Would an IF statement be potentially be used in this scenario?

    Thanks

  2. #2
    Conjurer Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    100
    Articles
    0
    Excel Version
    2013, 2016, O365
    Sounds like you'd need to do two merges. One, joining on the first column and a second joining on the second column. Then append the two results and remove duplicates.
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  3. #3
    Acolyte jilbobagins's Avatar
    Join Date
    Apr 2019
    Posts
    52
    Articles
    0
    Excel Version
    2016
    Yes I could, I'm struggling with the performance of this query and trying to get the desired result with a few steps as possible...

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,681
    Articles
    0
    Excel Version
    O365
    Can you post a workbook so we can see the data?

  5. #5
    Acolyte jilbobagins's Avatar
    Join Date
    Apr 2019
    Posts
    52
    Articles
    0
    Excel Version
    2016
    Unfortunately I can't as its a full of IP. The biggest thing with most of the queries now (certainly on more complex tasks) is making the things run quickly!

Posting Permissions

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