I have a workflow with many inputs from ODBC sources, and sometimes one (or more) fails. All of these data inputs are consolidated via a Union, but any errors result in the Union failing because no metadata is received from the stream(s) with errors. I do want the workflow to proceed even if one of the inputs has an error. Does anyone have a solution for this?
This is similar, but different since my first tool is a data input vs. a directory search (which is designed to handle files that don't exist, not connection problems).
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Ignoring-Missing-Data-Connection-for-Union-Tool/td-p/147943
A few things i've tried without luck (but hopefully might help get you thinking!)
- Adding a select after each input with the metadata configured,
- Adding a filter after each input which excludes null rows.
- Adding a generate row after each input to add a garbage row.
- Adding a macro after each input with the input optional.
- Adding a dynamic input after each input (there may be some way to accomplish this based on the above solution, but I couldn't figure it out)
- Configured the input tool SQL query with a union to a static value row, but fails since one part of the SQL-based union fails.
