Insert Statement in Alteryx.

[rohit782192]

Hello Team,

How we use Insert Statement of SQL in Alteryx.

[fmvizcaino · Accepted solution]

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 · Accepted solution]

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

Does this help?

Best,

Roland

[rajamahajan85]

Where you would define the schema/table?