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!
