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.
fireworks

dynamic input tool

Sreenibilass
5 - Atom

how to add delete scripts to dynamic input tool  

4 REPLIES 4
Sreenibilass
5 - Atom

added sample 

Qiu
21 - Polaris
21 - Polaris

@Sreenibilass 
Did not see any sample? 🤣

atcodedog05
22 - Nova
22 - Nova

Hi @Sreenibilass 

 

When you say delete script I am guessing you are speaking about SQL.

 

Input/ Dynamic input tool cannot directly run delete script. They can only run the select queries. To run delete query you can use pre-sql or post-sql statements like highlighted below which exists in both Input/ Dynamic input tool while using SQL connections

 

atcodedog05_0-1641027342815.png

 

Happy to help : )

Happy new year to you and your close ones : ) May it be filled with happiness and prosperity =D

mutama
Alteryx Alumni (Retired)

@Sreenibilass  some additional resources which may be helpful:

 

Hope these will help in your use case 🙂

Labels
Top Solution Authors