Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query: How to Merge two tables without adding more rows?

Hi All,   I am attempting to Merge a second table into an existing table, using `Merge Queries`, (not Merge Queries as New) to perform a V-Lookup.    When the VLookup is used, the 1st table does ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Yeah, I just realized my statement is not true.  Are you SURE there are not duplicates in the right table?  You can try this to be sure:

     

    #"Merged Queries" = Table.NestedJoin(#"Trimmed Text", {"UPC"}, Table.Distinct(VLookup_Combined, {{"UPC, Comparer.OrdinalIgnoreCase}}), {"UPC"},  "VLookup_Combined", JoinKind.LeftOuter)

     

    This makes only the right table distinct.

    ---Nate

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous so based on your anaolgy:

If I have 10 rows of "Nathan" in the left table, and 1 row "Nathan" in the right tabe... I should get a total of 10 rows.

 

However, when I expand the Merge columns, I'm getting 15 rows of "Nathan" (more or less).

 

If a merge is not possible, is there another way to perform a VLookup in Power Query?

 

Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yeah, I just realized my statement is not true.  Are you SURE there are not duplicates in the right table?  You can try this to be sure:

 

#"Merged Queries" = Table.NestedJoin(#"Trimmed Text", {"UPC"}, Table.Distinct(VLookup_Combined, {{"UPC, Comparer.OrdinalIgnoreCase}}), {"UPC"},  "VLookup_Combined", JoinKind.LeftOuter)

 

This makes only the right table distinct.

---Nate

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

    That did it!  I needed to make just the right table distinct.  

    Thanks!