Khoros Atlas Logo

Highlighted
Priyanka210
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")

Tags (2)
3 Replies 3
Khoros Alumni (Retired) ClaudiusH Khoros Alumni (Retired)
Khoros Alumni (Retired)

Re: Introducing the Alteryx Community

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

Re: Introducing the Alteryx Community

Thanks, @ClaudiusH!

 

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

0 Kudos
Reply
Loading...
nicolewells
New Commentator

Re: Introducing the Alteryx Community

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

Tags (2)
Reply
Loading...