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
BrandonB
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

BrandonB
Alteryx
Alteryx

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

Labels