Union tool memorizes the fields

Hello ,

I have this peculiar issue .

I have data which generates aeging buckets :

0-30 30-60 60-90 90-180

I am using union tool to merge two data streams before generating output .

But at times union tool generates error '60-90 field is missing in union' whenever there is no data in input for 60-90 bucket .

Also , this issue gets resolved when i rerun the workflow . Strange .

Any support appreciated .

Join

Accepted answers

ok you are saying there is an issue at first run but it gets resolved in second run. Thats definitely is strange.

Maybe the column was not initialized at first run. But it gets initialized after first run. And works properly for second run.

Just a thought 🤔 Not fix.

Yes may be true .

How to fix this .

When the workflow is executed manually we can re run . But on job this leads to job fail.

Thanks.

Agree with @atcodedog05 , are you certain the inputs are same for two runs?

and for the union itself, there are options on how to proceed when fields differ.

キャプチャ.PNG

Just add to it.

I think manual config on Union Tool not Auto config by name. Thats why its running into error.

Hi @Qiu ,

The issue is because one of the does not have data in the first run . In the second run when the file is loaded again issue is solved.

Thanks.

I tried to reproduce it, but I couldn't do it.

To avoid errors, you might try adding data stream that have only header by Text Input tool?