Forum Discussion

DataGuy2016's avatar
DataGuy2016
Advocate IV
9 years ago
Solved

Table Merge creates duplicate records

Hi Folks,   I am stumped.   I am trying to merge two tables into a new table using a LEFT JOIN.  Both tables have unique records on each row.  When I join the tables, BI creates duplicate rows on...
Need Help
  • DataGuy2016's avatar
    DataGuy2016
    9 years ago

    The problem lay with the Data.

     

    The LEFT JOIN functionality of PowerBI works perfectly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'm facing the same trouble here. Not sure why merging 2 tables create duplicates. Have anyone got a work around this? 

 

Update 9/10 : Problem Solved. My original first table already have got unique rows hence I should have merged it as aggregated values otherwise it will further expand the table, causing duplicates. Also, it helps to use and select more than one field as the key to look up if you need that level of granularity.