Ignoring Missing Data Connection for Union Tool

Hi All!

I am building a workflow that takes 3 different types of excel sheets and does a union on their data. I want to make it so that if any of the sheets is missing, it should still run.

Currently, if any one of the input files is missing, my workflow outputs and error, and doesn't union the other two files.

Is there a way around this?

Thanks!

Capture.png

Input

Error Message

Accepted answers

AdamR_AYX

I think the attached is the trick you need

The dynamic input will not error if it receives no data.

sample.yxzp

All comments

ivoller

Hi,

See this post and the solution from @MarqueeCrew. https://community.alteryx.com/t5/Data-Preparation-Blending/Join-occasionally-has-no-input-how-to-proceed/td-p/47245

Iain

umairmesiya1

Thanks for the link!

However, this works if i have a file that has zero rows. In my case, sometimes the Input tool doesn't have a file at all and causes my Union tool to fail, stopping the rest of the workflow.

kcgreen

I'm stuck on the same problem. I've attached a sample workflow in case anybody has an easy trick to solve it.

sample.yxmd

dkchandana3

I am encountering a similar problem. Were you able to fix in your case?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703