We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Creating DML script

singh28ashish
7 - Meteor

Hello Alteryx Experts,

 

Just wanted to know if we can make insert statement like below in Alteryx

 

Insert into ROCPS.Order (ID,DATE,Address) values (111,'2023-06-10',AU)

 

Above one is small example. In original tables we have around more than 30 columns. Is there any way we could achieve this dynamically.

 

TIA :)

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @singh28ashish 

 

Have you tried to use the output tool connected to the db and configured as insert if new or append? For me it seems that the result would be the same.

 

Anyway, if you really need to use insert statements, you can create them dynamically with cross tabs/transposes/formulas, and then use the dynamic input tool to send them to the db. Workflow attached.

column1.png

Labels
Top Solution Authors