Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Free Trial

Alteryx Designer Desktop Discussions

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

SQL

Raj
16 - Nebula

How to Create Dynamic and static connection With SQL?

3 REPLIES 3
gawa
16 - Nebula
16 - Nebula

hi @Raj 

 

I couldn't understand the meaning of "Dynamic and Static" but if you try to send dynamic query to single SQL server, you can use Dynamic Input tool.

First prepare template SQL query like this(in this case, I will modify where clause x value )

image.png

This case, by using x column value, where clause is replaced with "x=1", "x=2"...and get output.

image.png

 

As the above workflow only works at my computer, so sorry for not attaching as a sample.

Raj
16 - Nebula

what if i want to change the data set basis of condition?

gawa
16 - Nebula
16 - Nebula

I'm sorry, can you describe more detail on what you want to realize?

Labels
Top Solution Authors