CSV: Add or Remove Columns

Use this action to insert a new column at the end of an existing data table, or remove an existing column.

How to configure this action

This action creates a new CSV file for any modifications. The original CSV file will not be changed.

Fields for this action

• CSV file

  • Enter the name of an uploaded CSV file or use a field reference.

• Columns

  • Enter an ordered list of the column header names to be added or removed, separated by commas.
    • Duplicate columns cannot be added.
    • Columns are matched by their name and is case-sensitive.
  • Enclose a header in quotation marks if it contains special characters such as commas, leading and/or trailing whitespace, and newlines. If the value contains quotation marks, they must be escaped with a quotation mark.

• Action

  • Choose from ADD, REMOVE or BOTH.
    • ADD: Add the columns listed in Columns configuration field.
    • REMOVE: Remove the columns listed in Columns configuration field.
    • BOTH: If a column exists in the Columns list, but not in the CSV, the column will be added. If a column exists in the CSV, but not in the Columns list, the column is removed.

  • 

• Output field name

  • Enter a name for the field in which the result should be saved.
  • The step’s name is used as the output field name by default.

What will this output?

The name of the output field where the updated CSV is stored will be the Output field name defined during configuration.

For all other fields, the output field name above will be added to the beginning of each of the output field names, separated by two dashes. Each field will result as:{{output-field-name--output-field}}

Output fields for this action

• Output field name

  • The new CSV file. The file name and extension will be identical to the original CSV file.

• Columns added

  • A comma separated list of all columns added by the action.

• Columns removed

  • A comma separated list of all columns removed by the action.

• Original columns

  • A comma separated list of all column headers from the original file.

• New columns

  • A comma separated list of all column headers in the new output file.