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

  • Click the Select Data Table drop-down menu and select an existing data table.

    If there is no existing data table, click the Create variable icon to create one.

  • Use the Select column by field to select one of the following tabs:
    • Name: Enter the column name.
    • Index: Enter the column index.

      For example, to set a value to the first column, enter 0.

  • Click the Select the new column data type drop-down menu and select one of the following option for column data type
    • Number
    • Boolean
    • String
    • Datetime

      If you select Datetime, you can format the values by selecting a predefined format or specifying a custom format.

      Note: 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.
  • Click the Save the outcome to a variable drop-down menu and select an existing variable.

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