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

MARTHA

https://community.dataiku.com/discussion/44892/core-designer-certification-question-join

Are you sure you are using the correct columns for the join?

Have you checked the data set that has Urban %? Apparently for the same key, you have two different rows in it.