Because of one "&" in all of my dataset, that was in .csv file contaminated the whole join. It was deceiving because it joined successfully, but on the export, all the new values were null. Once i removed the "&" in one of the values, the data exported correctly.
... View more