Alteryx Designer Desktop Discussions

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

Anonymous code blocks in "Pre SQL Statement" is split into several statements

Adalbert
6 - Meteoroid

Hi!

I'm using Input Data Tool with SingleStore and want to execute an anonymous code block in the "Pre SQL Statement".  

The problem is that Alteryx splits it by semicolon and sends it to the ODBC driver one by one.

The same problem happens with create procedure statements.

Is there a way to configure Alteryx to not split statements in the "Pre SQL Statement"?

 

1 REPLY 1
mbarone
16 - Nebula
16 - Nebula

@Adalbert - did you ever find a workaround for your code to make your presql statement work?  encountering the same issue.

Labels