Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
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