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 having issues running a SQL Server query in Alteryx. My assumption is that it is related to the local variables that were created by the developer and Alteryx not being able to read in those variables.
Is there a proper way to get those variables written in so the data runs through Alteryx?
Is the correct way to place the variable portion of the query in the "PRE SQL Statement" section and the entire query in to the "Table or Query" section?
Yes you can add a Pre-SQL statement to your connections. Under options on the configuration panel of the input source in question take a look at option 9, it allows you to add a statement, further option 11 gives you the ability to add a Post-SQL statement