Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

In-DB Tool Error

Highlighted
8 - Asteroid

I am getting the below error when I am using the In-DB tools.

Due to the amount of data this query is pulling I am using In-DB tools and I am getting the error below.

When I use the Input Tool it runs (far too long) fine.

 

error.jpg

Highlighted
8 - Asteroid

issue had to due with aliases.

Because In-DB takes advantage of CTE’s, Alteryx adds its own alias to the CTE’s it creates, which conflicted with initial query already contains aliases.

Labels