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.

Need to create an empty table in oracle

PaulFields2
8 - Asteroid

I have a set of workflow steps using in-db nodes that run inside of individual containers, any one of which might or might not necessitate the use of a temporary table in my oracle db, into which I would need to place the results of those workflows.  Being able to create an empty table from a data definition would be very helpful, so that I know that the fields will be large enough to accept the data, and so that I can count the records in that table afterwards.

 

I am not finding a way to create an empty table from DDL in Alteryx.  Can you let me know if and how I can do this?

3 REPLIES 3
bbak91
Alteryx
Alteryx
PaulFields2
8 - Asteroid

Yeah - I read that one, but not exactly what I was looking for.  I'd really like to use a CREATE statement just as one would do in a SQL editor.

 

Thanks

bbak91
Alteryx
Alteryx

The "Create New Table" option within the Output Data tool is creating the table directly from Alteryx

Labels
Top Solution Authors