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.
Does anyone have tips on how to use the in-database formula tool with Oracle? No matter what I try, it errors. The connection to the oracle database is fine and the SQL in the query is good also. But for some reason, it won't show the results from the data pull and calculate the formula in the formula tool, even though the results are there.
The error is:
Formula In-DB (3) Error opening "WITH "Tool1_34a0" AS (Select .....
and no columns returned.
Thank you so much and also, I'm new to the Alteryx community as well as Alteryx so if there is something I should read or somewhere else to reach out, please let me know. Thank you again.