topic Union Tool - Not Stacking Data Together in Alteryx Designer Desktop Discussions

Union Tool - Not Stacking Data Together

Kristie_Pires — Mon, 02 May 2022 01:42:38 GMT

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!

Re: Union Tool - Not Stacking Data Together

MarqueeCrew — Mon, 02 May 2022 02:09:35 GMT

@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

Re: Union Tool - Not Stacking Data Together

Qiu — Mon, 02 May 2022 02:22:37 GMT

@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.

Re: Union Tool - Not Stacking Data Together

Kristie_Pires — Mon, 02 May 2022 14:14:17 GMT

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