Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Duplicate data after merging tables with left outer join

i am getting duplicate data after merging tables with left outer join.

I have merged SCD table with Fondsatellite with left outer join

Similarly I have joined newly merged scd table with another merged table (Fund satellite and summary list) with left outer join.

What is the reason I am getting  exactly duplicate data ? Its not duplicate but doubled up..The actual results should be exactly half of what is showing

 

 

 

 

 

 

Need Help
Show and Tell

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous ,

     

    Please provide some dummy data in source table so that I can reproduce the same scenario on my side. Besides, are all fields shown in above table visual original columns in data table or calculated measures?

     

    Regards,

    Yuliana Gu