Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Union Tool - Produce output if input streams are blank

cmStuhl
7 - Meteor

Hi All, 

 

I am looking for a workaround for the union tool - The input data on this workflow will be variable so I need to consolidate data streams into a single file. Currently I have different streams for different data that are combined at the end using the union tool. However, if any of these streams are blank the union tool will fail. Is there a better way to do this? 

 

Thanks

3 REPLIES 3
Raj
16 - Nebula

@cmStuhl 
one workaround is you can add a dummy line of data for each input
and then union this and after that use filter tool to eliminate the dummy data

apathetichell
19 - Altair

use a count records tool. count records will produce a count of 0 if there are no records.

cmStuhl
7 - Meteor

Thanks! I used the dummy line of data and that worked!

Labels