Public
New Commentator

Generate SQL query from Alteryx

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?

 

(Title Edited by moderator to reflect content. Was: "Introducing the Alteryx Community")

3 Replies 3
Khoros Alumni (Retired)

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/


Khoros Best Practice until August 2019. Onwards posting as Claudius.
Learn how to master Khoros. Learn Best Practice in the Community Documentation
If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.
Honored Contributor

Thanks, @ClaudiusH!

 

@Priyanka210 - Looks like you made your way over to the community. See you there 🙂

New Commentator

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

 

I hope this will helps you! 

 

Regards

Nicolewells

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.