dynamic input tool

[Sreenibilass]

how to add delete scripts to dynamic input tool  

[Sreenibilass]

added sample 

[Qiu]

@Sreenibilass 
Did not see any sample? 🤣

[atcodedog05]

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

Happy to help : )

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

[mutama]

@Sreenibilass  some additional resources which may be helpful:

• Dynamic Input Tool Mastery Guide: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/249... 
• Pre/Post SQL Statements in Alteryx (great idea by @atcodedog05!): https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Pre-Post-SQL-Statements/ta-...

Hope these will help in your use case 🙂