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'm using the union tool in one of my workflows, and from time to time I will get an error saying "Internal Error: The input "#2" was not initialized."
This error happens when there is no data flowing in on one of the connections, is there any way to prevent this error? There are times when data will only flow from 1 connection, and other times it will flow in from both. What's the best way to resolve this?
When I've seen this, I am using a detour and not pushing any data to the UNION. If I use a SELECT RECORDS with a value of 0 or use any method that doesn't push a record, but still creates the metadata for the record stream, the issue goes away. It sounds like you have no data flowing, rather than 0 records. If you can force metadata into the connection, this should go away.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
My workaround is to create a separate workflow which reads the outlook into a separate file then combine the new file with your other input file. The issue I now have is that when i run the new workflow the input tool combines my columns into one even though i have defined the comma as the delimiter. Why?
DateTimeReceived and Subject should be two separate columns!
I place a Select Tool at the end of each stream that feeds into the Join tool. I also place a Block Until done tool prior to each stream that feeds the Join with #1 row in the Join connected to #1 on the Block Until Done and #2 row in the Join Tool connected to the #2 connector on the Block Until Done tool.