Workspace 6.21.5
InsertColumnIntoSqlTable

Add a column and data to a table. Data may be updated without adding a new column by setting a flag.

  • Default label: "Insert column into SQL database table"
  • Member of plug-in: Data analysis
  • Catalogue path: Database
  • Polymorphic: InsertColumnIntoSqlTable is a Polymorphic Operation. One or more of its inputs and outputs are not listed below because they are created dynamically whenever the operation changes its data type, and when it is first created.
Inputs:
DatabaseModified-in-placeQSqlDatabaseThe database containing the table to modify.
Table nameQStringThe name of the table where column is to be added or modified.
Column nameQStringThe name of the column to be added or modified.
Count must matchboolWhen set, the length of the data to be inserted/updated must equal the number of rows in the table.
Overwrite existingboolWhen set, data in an existing column is updated.
DataCSIRO::DataAnalysis::DataSeries

Outputs:
DatabaseQSqlDatabase

The database containing the table to modify.