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.

aavilap's avatar
aavilap
Helper I
8 years ago
Hi I’m having the exact same issue when merging two tables, I see you posted that the issue lays with the data and not the merge, can I ask how you solved it? I’m pretty sure I have unique values so I believe that is not the issue, actually the merge is working on someone else’s computer but not on mine. Appreciate any hint you may provide.
LiongMei1's avatar
LiongMei1
Regular Visitor
3 years ago

Hi, you may try to match more than one field to obtain a unique set of data match.