IN-DB Append New Field to Existing Table (Oracle)

[WSDATA]

We mostly read and write local data with Alteryx.  We are currently setting up an Oracle table to hold some larger tables.

Once the tables have been created, we are trying to figure out how to add new fields when we are appending new data (rows).

We have tried to read the original data and union it then use the write data IN-DB tool.

We have tried creating new fields using the formula IN-DB control and then passing it to the write IN-DB tool.

For the write data IN-DB tool, we have used both the Append data and Overwrite Table (Drop) settings. 

In all cases our appended rows are successful, but the new field(s) never makes it in the table.

Does anyone have any best practice on how to not only add rows, but to modify data types for fields in tables and add new fields?

Thanks in advance for any help!

[atcodedog05]

Hi @WSDATA 

A possible option is you can union new data and old data and then overwrite the table.

[WSDATA]

We tried that but when using the Overwrite (Drop) option in the IN DB Write tool, we get an error (ORA 000942) that it can not find the table.  I can see from the log that it "drops" the table, then later when trying to write it says the table does not exist.