Results 1 to 5 of 5

Thread: Selecting Join Kind

  1. #1
    Neophyte jessepatcher's Avatar
    Join Date
    Feb 2020
    Posts
    4
    Articles
    0
    Excel Version
    2016

    Selecting Join Kind



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

    I'm on office 2016, windows 10. I have to merge 2 files that have a common field. Neither file has duplicates of the common field. Each file has record that the other doesn't have, and aI need a Master file. When I get data for the queries, in the Merge dialog box, there is NO Join kind dropbox. There is only a checkbox that says "only include matching rows". I need to include rows that have no match in each file. Why am I missing the Join Kind dropdown?
    I tried going straight to Power query after Get Data step, and the I clicked Merge, but the same problem displays: I don't have "Join Kind" dropdown arrow. Thanks for any help

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,374
    Articles
    0
    Excel Version
    Office 365 Subscription
    Perhaps you should be appending rather than merging?
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,691
    Articles
    0
    Excel Version
    365
    Is this you at Mr Excel:
    https://www.mrexcel.com/board/thread...ialog.1125233/
    ?

    If not fine, but if so, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them as well.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  4. #4
    Neophyte jessepatcher's Avatar
    Join Date
    Feb 2020
    Posts
    4
    Articles
    0
    Excel Version
    2016
    Quote Originally Posted by AliGW View Post
    Perhaps you should be appending rather than merging?
    No, I don't think so, because the 2 files have different columns and different number of columns. And many records are common to both files, but each has some records that the other doesn't have, so I think this would be an Outer Join ? A full Join? Not sure what it's called.
    thank you

  5. #5
    Neophyte jessepatcher's Avatar
    Join Date
    Feb 2020
    Posts
    4
    Articles
    0
    Excel Version
    2016
    I read the article you linked to, expressed my apologies.
    thank you.

Posting Permissions

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