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.
The variable is not dynamically created or altered in any way. It comes in the same format from the original data source. The workflow itself runs with no errors in Designer. It is only when I publish it in the Gallery that there is the error.
Is the original data source that contains the variable accessible in it's location by the server? If you have not packaged the data with the workflow when you uploaded it, then the server workflow is trying to access that original data source, and if that is, for example, stored locally on your PC then it won't be able to read it, and the variable will therefore not exist.
All 3 files that are read in are stored on a network drive that is accessible by the Alteryx server. The first 2 files are ready in successfully without a problem. This third file appears to be read in, but doesn't have the error until the middle of the workflow.
I did a force rename with a Select tool and then did a multi field formula with [_Current Field_] as the formula. That did it!! Now it runs successfully. Root cause of why it didn't work before is not understood, but at least it is published successfully.