Solved: Union Tool - Errors on joining empty inputs

[furlonla]

Hi, 

I am using the union to bring 5 different figures that I have summarised together (see screenshot). Sometimes some of these are blank. In the case below only #2 has data. As such the entire output is empty. 

Is there a way to get the output for this?

Thanks,

Laura

[furlonla]

Sorry my Alteryx skills are not great. Will I need to bring in the text input tool 5 times. My orignal input in the workflow is one Excel sheet from which I'm taking different tab. Which of the join tools should I be using. Please see screenshot. thanks for all the help. 

[Emil_Kos · Accepted solution]

Hi @furlonla,

You need to add one dummy input per union that isn't working to make it work again.

On your screenshot you got two unions so connect the dummy data to both of them and it will make it work!

[furlonla]

Thank you for your patience, this is working for me!

[atcodedog05]

Glad it got sorted 🙂

Happy to help 🙂

Cheers and Happy Analyzing 😀