Combining two datasets

[Wael03]

Hello, 

I have two dataset with the same columns name : 

I combined them using the append queries method everything worked perfectly but it didn't work for one column "native name" and I don't understande why :

As you can see first it created a new column native name 2 for no reason and it only worked for the native dataset but for all the co badge it is null.

If yo know how to solve it would be kind thank you in advance !

[Wael03]

Yes they are both "text" 

[mario_ruiz]

in both sources(datasets), the data type of the Native column is it the same? Both columns need to have the same data type to work properly.