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?
Here is one method of approaching this: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-table-from-schema-definition/td...
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
The "Create New Table" option within the Output Data tool is creating the table directly from Alteryx