To combine data faster from enabled and disabled containers.

Question

Hi All,

How can one combine data which comes from different containers even when some of those containers are disabled?

Generally I replicate the tools as per the number of outputs required.

Unions, joins and appends don't work unless all inputs are initialized.

Is there any other quicker way or any another way to do the same?

FilipR · Answer

Maybe my solution for errors in Formula tools will work for you.

I am adding an "Error Handler" to the Union which has the column names, but no data. See attachment.

Then again, in the link you attached, they mention the Detour tool. If you have it in your workflow then it's probably the reason for the error you're experiencing. It completely shuts off the tools. If you are using it, make sure you end it with the Detour End instead of a Union.

New Workflow6.yxmd

NaomiMariaThomson · Answer

It does apply in the workflow you shared but I have still faced that error.

I searched in the community now and found a similar case being mentioned as shared below:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Union-tool-input-not-initialized/td-p/157163

FilipR · Answer

A Union tool will work even if there's only one active input. Test it yourself by disabling the container. Please see attached:

New Workflow6.yxmd