How to generate SQL query from Alteryx
how can I view the SQL query that alteryx is using to run my workflow?
I've googled and found info about a 'dynamic output' node, but I can't find that node in alteryx - it might be in a previous version?
Hi @Priyanka210 and welcome to the Lithium Community,
I assume your question was in response to the introduction topic for the Alteryx Community by @BrianOblinger. Keep in mind though that this community right now is from Lithium Technologies which provides the customer experience backbone to make the Alteryx Community successful.
Best if you re-post your question directly on the Alteryx Community at https://community.alteryx.com/
Hello @Priyanka210, To known how to generate SQL query from Alteryx here are the few point's go through it.
Important: If you change the SQL statement, make sure to make any necessary related changes to the Action tools as well.
Sometimes you may need records removed from a database table before adding in new records. This can be done using the Pre SQL Statement in the Input tool, which will run an SQL query before, for instance, appending new records to the table. However, what if you do not want to run the same delete statement every time? For example, let's say that you need to delete all records that match a particular date for every run?
For detailed information visit this link! https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Delete-Records-Using-a-Post-SQL-Statement-Ma... AlterYX
I hope this will helps you!