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

[RichardAlt]

Hi guys,

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

Both has data.

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

But when I run the workflow and check the union.

It showed null.

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

[patrick_mcauliffe]

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.

[JunePark]

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)

[RichardAlt]

Nope, 

This are the columns in union tool.

[RichardAlt]

Hi @JunePark ,

This is the select tool of my first source file.

This is the second one,

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

[benakesh · Accepted solution]

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

[RichardAlt]

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.

[patrick_mcauliffe]

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