This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am getting the following error "Union Tool Input #1 Not Initialized" I understand why I am getting it and looking for thoughts on how to test for it.
Simple workflow with an input tool with a date/time in it
The date/time is passed to a Salesforce tool and replaces a specific string. The query runs and Lucky Charms appear at the other end. Everything is Magically delicious until the date/time I pass is newer than what is in the table. This is where the errors occur.
So my thought was to try and test the results coming out of the Salesforce tool (Count Tool) and avoid passing anything to the union where the record count < 1. Then proceed to the bottom line of the flow, swap values with the other count tool, then finish the bottom row of the flow (log it ran, returned zero records, etc).
I have not come up with any solution that works and feel that I am really overthinking what could be an easy solution.
Hi @stapuff, Reading your note it looks like your Saleforce connector does not output data for some dates, which the union tool is looking for, and errors out since it doesnt find anything coming from the Salesforce connection, yes? Union tool from my experience shouldn't error out if you are using an Auto Config in its config.
Can you confirm your Union tool setup? do you have 'Auto Config by Name' or 'Manually Configure by Fields'?
Could you refactor your Salesforce query to return atleast one record no matter what, which we can filter downstream in Alteryx? The SQL could be a union of System date and base query you have. That way it'll always output something and the issue would resolve itself?
Alternatively, there are some solutions suggested in the following community page for you to look at: