ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamically update presql in output

citronmelisa
8 - Asteroid

Hi! 

From https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Use-Dynamic-Input-with-Pre-SQL-Stateme... I understand an option is to make a simple macro that updates presql
Is there any other way or workaround how to dynamically update the pre/post sql when outputting to DB?

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @citronmelisa 

 

Unfortunately, the only way to update pre/pos sql statements is through a macro, like you saw at this post.

citronmelisa
8 - Asteroid

thanks @Felipe_Ribeir0 !

Labels
Top Solution Authors