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

Alteryx designer Discussions

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

In-DB Tool Error

Highlighted

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

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