MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Insert column | Parameter
 
Parameter
The following parameters are available.
Action
Result
Column name
Name of the new column.
Source: Constant
Data type: Date, Number, or Text
Specification: Mandatory
Type
New column data type; Date, Number, or Text.
Default value: Text;
Specification: Mandatory
Create numeric enumeration
Fills a new column with ascending values. The values start at 1 or the value entered in the Value input box and increase by a value of 1 in each subsequent row.
Specification: Optional
If the option is enabled the Value box is disabled and any (default) value already entered or selected is deleted. Incoming connections for dynamic values are ignored.
Value
Initial value of the new column.
Source: User input or constant and source table
Data type: Depends on the data type of the source column.
Specification: Optional
If a name of an existing column is specified as the column name, regardless of its data type, this has no effect on the result table, i.e., the original column values are retained. Existing columns are not overwritten by new columns with the same name. Multiple columns with the same name cannot exist in a table.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release