Forum Discussion

Osmento's avatar
Osmento
New Member
9 years ago
Solved

Merging table with a left outer join

Hi Everyone,   I have two table that I am trying to merge data in.   In my Travel Data table I have an Origin Code, which relates to the airport of departure.   In my Origin IATA Codes this is ...
  • ImkeF's avatar
    ImkeF
    9 years ago

    What is the result if you choose "Right Outer Join" instead of "Left Outer Join"?

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

Osmento your excel tables, does it show the code you are joining on?

  • Osmento's avatar
    Osmento
    New Member
    9 years ago

    So the origin is from the first table and everything from AQ onwards is from the left joined merge table.  So the merge has completed but it has also duplicated the data.

     

    • ImkeF's avatar
      ImkeF
      Community Champion
      9 years ago

      What is the result if you choose "Right Outer Join" instead of "Left Outer Join"?

      • Osmento's avatar
        Osmento
        New Member
        8 years ago

        Yesterday I tried every type of join and didn't get the correct figure. 

         

        When I tried the right outer today the fugure was correct.  Thanks for your help.