Change column type action

The Change column type action in the Data Table package enables you to change the data type of a column.

Settings

  • Select the data table name from the drop-down list.
  • Select whether to specify the column by Name or Index.
    • If you select to specify by name, enter the column name.
    • If you select to specify by index, enter the column index. For example, to set a value to the first column, enter 0.
  • Select the new column data type from the drop-down list to Number, Boolean, String, or Datetime.
    • If you select Datetime, you can format the values by selecting a predefined format or specifying a custom format.
    • To specify the format applied on the input data table variable, select an option either from the predefined format list or enter the value in a custom format.
  • Select a table variable to include the output.

    You can either select the source table variable to overwrite the values or select a different table variable.