Forum Discussion

Dillard70's avatar
Dillard70
Regular Visitor
8 years ago
Solved

Merging Table - Using Merged Table & Original Unmerged Dataset

I work in the mortgage industry and am trying to analyze data on files originating from purchased leads, and files that originated from all other sources (generally referrals from previous clients or...
Need Help
  • danextian's avatar
    danextian
    8 years ago

    Hi Dillard70,

     

    In Power Query, there isn't just one kind of merge. There are actually 6. The most common of them is Left Outer which is very similar with Excel's VLOOKUP. 

     

    If your merge query returned just the matching row between the two tables, the what you did was most probably an Inner join.

     

    If you need to find the rows tht are in the first but not in the second table, you may use Left Anti. Otherwise, use Right Anti.

danextian's avatar
danextian
Super User
8 years ago

Hi Dillard70,

 

In Power Query, there isn't just one kind of merge. There are actually 6. The most common of them is Left Outer which is very similar with Excel's VLOOKUP. 

 

If your merge query returned just the matching row between the two tables, the what you did was most probably an Inner join.

 

If you need to find the rows tht are in the first but not in the second table, you may use Left Anti. Otherwise, use Right Anti.