Union Tool - Produce output if input streams are blank

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

alteryx example.pdf

Workflow

Developer

Developer Tools

Input

Error Message

Connectors

Help

Join

AMP Engine

AMP-Engine

Accepted answers

Raj

@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

All comments

Raj

@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

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

cmStuhl

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703