Introducing the Alteryx Community

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?

Tags (2)
Message 1 of 4
3 REPLIES
Highlighted
Community Management
Navigation

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/


Learn how to master Lithium. Visit the Best Practice Center

Previously known as Claudius. New profile - Now even more content
If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.
Message 2 of 4
Community Management
Analytics

Thanks, @ClaudiusH!

 

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

Message 3 of 4

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! 

 

Regards

Nicolewells

Tags (2)
Message 4 of 4