In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

SQL table connection through output Tool

Puneet13
8 - Asteroid

I need a help wherein I have multiple Input and I want to these output in a SQL table, currently I have no table available in SQL to add data, can somebody tell me how to create a table using Alteryx with data automatically paste in the SQL table or any other procedure use to insert the data into table. Also I want to delete the data from the SQL table and insert new one. Can somebody help me with sample workflow where in above steps are coveted

3 REPLIES 3
alexnajm
19 - Altair
19 - Altair

Attaching a workflow will be a challenge since we don't know your workflow and don't have your SQL connections, but all of the output options you mentioned are in the Output Data tool:

SQL table connection through output Tool.png

Puneet13
8 - Asteroid

I have tried with create a new table option but every time I m getting error of ' no table are selected'.

alexnajm
19 - Altair
19 - Altair

That will all depend on your connection settings (i.e. do you have create/write access) and the database you are connecting to - I would search on the Community for those specifics and try again!

Labels
Top Solution Authors