ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Keep errored data flows from entering a union tool

8 - Asteroid

I have a workflow in which I need to make 3 FTP file pulls using the download tool, then union the data from all 3 pulls together. Occasionally, one of the files does not exist, which means that data stream produces an error. When this happens, none of the data from the other 2 functioning data streams go through the union tool.


How can I ensure that data from all present files still goes through the union tool when one of the 3 download tools produces an error?

11 - Bolide

Hi @kaianderson,


When there is a potential that some of the data will not exist, I like to use dummy data that I can filter out later. In this instance I would recommend having one simple bit of xml data that you union after your download tools. I would just make sure that this dummy data is identifiable and distinguishable from your actual data so that it will filter out nicely.