Alteryx Designer

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

Union Tool: Not getting the data in other source file.

Highlighted
8 - Asteroid

Hi guys,

 

I have 2 source files. I need to combine those 2 using union tool.

RichardAlt_0-1588847355030.png

Both has data.

This is my second source file as you can see it has data.

 

RichardAlt_1-1588847432819.png

 

But when I run the workflow and check the union.

It showed null.

RichardAlt_2-1588847510340.png

Any ideas why I'm getting this? Thank you.

 

Highlighted
13 - Pulsar
13 - Pulsar

Scroll over to the right.  Are there additional columns with the same name?  There might be column names with whitespace coming in from one of the inputs.

Highlighted
8 - Asteroid

Hi, I'm not sure but how about checking these below.

1. Did you try manually aligning the fields within the Union Tool?

2. Was the data type for two input anchor in the union tool the same? (Check the select tool)

 

 

Highlighted
8 - Asteroid

Nope, 

RichardAlt_0-1588852539168.pngRichardAlt_1-1588852583513.png

RichardAlt_2-1588852615122.png

 

This are the columns in union tool.

 

Highlighted
8 - Asteroid

Hi @JunePark ,

 

This is the select tool of my first source file.

 

RichardAlt_0-1588852702872.png

RichardAlt_1-1588852726239.png

 

This is the second one,

 

RichardAlt_2-1588852759211.png

 

And also I set the Union tool as Auto Config by name.

Highlighted
12 - Quasar

@RichardAlt ,

 

Looking at  second  input  I think  you need join tool  instead of union  . Use join tool  with  key : 'report legacy key' ( common column   in both inputs)  . 

Highlighted
8 - Asteroid

Yes, Join tool works, But it triples my data. 

In union I have 35,000+ Data,

Now in Join tool, it has 82,000+ data.

Highlighted
13 - Pulsar
13 - Pulsar

@RichardAlt  can you post the workflow with the sample data you have shown?

Labels