Union Tool - Not Stacking Data Together

[Kristie_Pires]

Hi there,

I am trying to "Union" two datasets and the configuration is:

However, even if the column name and the datatype is the same; instead of stacking the data on top of each other, I get two columns with the same name but one containing data from dataset 1, and the other containing data from dataset 2. 

Is there something I have to ensure is the same so the Union tool stacks the data on top of each other instead of creating two columns?

Thank you so much!

[MarqueeCrew · Accepted solution]

@Kristie_Pires ,

 interesting concept.  Can you switch to manually configure (instead of auto by name) and see if the banners are truly the same (case insensitive).  You can also move fields together wit arrows ➡️⬅️

cheers,

mark

[Qiu]

@Kristie_Pires 
Most likely there are some white spaces in the field names of the "two columns with the same name".
Can you double check if there is any space before or after the field names?

Basically Alteryx will not allow two fields with the same names.

[Kristie_Pires]

Thank you @MarqueeCrew - I ended up manually configuring the Union tool, and that worked. But the banners were not the same.