community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

In Database Formula tool - working with Oracle

Meteor

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.

Alteryx Certified Partner

Looks like you are using a common table expression. You might find this post helpful:

 

https://community.alteryx.com/t5/Data-Preparation-Blending/common-table-expressions-in-database-work...

 

Labels