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
Solved! Go to Solution.
@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
use a count records tool. count records will produce a count of 0 if there are no records.
Thanks! I used the dummy line of data and that worked!