Delete column action in the Record package

Use the Delete column action to delete a column from an existing record variable based on the column name or index.

Settings

  • In the Actions palette, double-click or drag the Delete column action from the Record package.
  • Click the Source record variable drop-down and select an existing source record variable.

    If there are no existing record variables, create one.

  • Use the Delete column by field to select one of the following options to delete a column :
    • Column index: to specify a column position in the record variable.

      Indexing starts at 0. For example, enter 5 to indicate the sixth column from the left.

    • Column name: to specify the name of an existing column.
      Note: The column name is case sensitive. Ensure that you provide the correct column name. If there are duplicate column names, then the first matching column from the left will be deleted.
  • Click the Destination record variable drop-down to select an existing destination record variable.

    (Optional) Click the Create variable icon to create a record variable. For more information, see Record variable.