Need to create an empty table in oracle

Question

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?

BrandonB · Answer

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

PaulFields2 · Answer

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 · Answer

Here is one method of approaching this: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-table-from-schema-definition/td-p/105348