Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Insert Statement in Alteryx.

rohit782192
11 - Bolide

Hello Team,

 

How we use Insert Statement of SQL in Alteryx.

3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor

Hi @rohit782192 ,

 

If you are searching a way of using the sql command in alteryx, check the link below.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Pre-Post-SQL-Statements/ta-...

 

Or do you want to reproduce the command with Alteryx tools?

 

Best,

Fernando Vizcaino

RolandSchubert
16 - Nebula
16 - Nebula

Hi @rohit782192 ,

 

I assume, you want to insert data you generate in an Alteryx workflow into a table in SQL, right? Using the Output Data tool, select as "Output Option":  "Append Existing" (insert into existing table).

14-01-_2020_18-56-15.png

 

Does this help?

 

 

Best,

 

Roland

rajamahajan85
7 - Meteor

Where you would define the schema/table?

Labels