Core Designer Certification - question join

Charlotte

Dear all,

I'm currently working on the Core designer Certification project and I have an issue when I try to join the 3 CSV files (CO2 and Oil ; Urbanization GDP and Population ; Meat and Egg Production). When I do a left join with CO2 and Oil as the base, I have duplicated lines for each Entity/Code/Year with one with correct values and the second one with Urban (%) = Per Capita CO2 emissions.

I do not undestand where the second line comes from. Would you have any idea ?

Many thanks in advance.

Charlotte