We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
Top Solution Authors