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.

Workflow

Developer

Developer Tools

Accepted answers

benakesh

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

All comments

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.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335