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.

zzzzoooo's avatar
zzzzoooo
Frequent Visitor
7 years ago
othmanalazzam wrote:

Hi people.

 

I've been looking for this issue with no luck as well until I founded a valid work around.

 

the work around goes like this ::

 

-Merge your sheets as you like (you don't have to merge on more than one column, one is fine).

 

-Add index column

 

-Expand your merged column (this will create duplicate values, the main issue we're looking into).

 

-since the values in the "index column" were purely unique, now Remove duplicates using index column.

 

-and now your data is back to original as it was inteded to be.

My duplicate issue is solved by applying this method. Thank you very much.

RodgerB's avatar
RodgerB
Frequent Visitor
6 years ago

I've been working with a sales table and trying to create dimension tables from the table with all of the fields.  I've been frustrated, because I could not tell where the duplicate rows of data were coming from; however, could tell they happened after one of the two merge query steps.

 

I can affirm that having a unique index prior to the merge, and then removing duplicates from this field works.

 

Does anyone know why this occurs?