AddNewColumn

It helps the user to add/ update with a “new column” to the “Existing input datatable” during the runtime.

Properties

INPUT

Datatable:* Enter the “Input datatable” variable where the input data is stored. This parameter helps you to add a new column. This field only accepts the “datatable” data type.

Datatype:* Select the data type which is required to be added in  the “Column”.
Int: It accepts only the “Integer” datatype. (For e.g., 1,2,3).
String: It accepts only the “String” datatype (For e.g., sample).
DateTime: It accepts only the “DateTime” datatype. (For e.g., 01/01/2001 12:00 AM).
Double: It accepts only the “Double” datatype. It refers to the floating-point and decimal values.  (For e.g., 123.456 or -3.145).

DefaultValue:* Indicate the “Default value” that should be automatically filled for the column values. This value will be consistent for all rows in the column.
You can only assign “default values” to the columns; it’s not possible to add multiple values. This field only accepts the “string” data type.

Name:* Provide the “Header” for the column to be inserted into the table. This field only accepts the “string” data type.

Position:* Indicate the “Position” for the column where it should be inserted. This refers to the “index” position to which the column needs to be added. This field only accepts the “int” data type.

MISC

DisplayName: Displays the name of the activity. It can also customize the activity name to helps in troubleshooting.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False”. By default, it is set to “False.”
True: Continues the workflow to the next step.
False: The workflow aborts if it throws any error.
None: If the option is specified as blank, by default the activity will perform as “False” action.
Version: It specifies the version of the Datatable automation feature in use.

OUTPUT

Result: It helps to view the execution state of the activity. It returns the values in Boolean format.
True: It indicates the activity has been executed successfully without any error.
False: It indicates that the activity has been faulted due to some unexceptional error thrown.

* Represents mandatory fields to execute the workflow