Union tool memorizes the fields

[praneshsapmm]

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 .

[atcodedog05]

Hi @praneshsapmm 

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.

[praneshsapmm]

Hi @atcodedog05 

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.

[atcodedog05]

Hi @praneshsapmm 

I understand where you are coming from.

I dont know the fix. Either you can wait for some time others to respond if no response you can reach out to

support@alteryx.com mail id.

[Qiu]

@praneshsapmm 

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.

[atcodedog05]

Hi @Qiu 

Just add to it.

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

[praneshsapmm]

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.

[atcodedog05]

Hi @praneshsapmm 

Suggestion dont manually config the Union tool. Use a select before Union to rename(to match) and in Union Auto config by name. That should work.🙂

[AkimasaKajitani]

Hi @praneshsapmm 

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?