Creating DML script

Question

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

Felipe_Ribeir0 · Accepted Answer

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.