community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Union Repeating Columns/Fields

I unioned two sets of data having 38 fields each. One has 592 records and the other has 946 records. The union of the two gives me 1538 records which is perfect BUT it also gives me 40 fields instead of 38 with two fields repeated. I put select tools in front of the input tables and checked that the data type is exactly the same. Any idea why it might be repeating and what I can do differently to solve it? 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @saiharish 

 

A good way to check if your fields are exactly matching is to drag Field Info Tool to both of your data sets and join these results by "Name" and "Type".

 

This way you can see if there's a slight difference that maybe had passed through your eyes and you weren't able to identify.

 

Here's an example:

 

fieldinfo.PNG


Cheers,

Nebula
Nebula

Hi @saiharish 

 

Check to see if the one of the repeated columns has leading or trailing spaces in the column name

 

Dan

Labels