Tables: Remove a Column

Use this action to delete a column from an existing data table.

Use case

If a table contains extra information that is no longer needed or collected, the Tables: Remove a Column action can clean up the data table by removing an unneeded column.

For example, if an instance is updated and the form within the instance no longer collects a certain field, using the Tables: Remove a Column action will delete the unnecessary information.

How to configure this action

The Tables: Remove a Column action will modify the existing table, this keeps the Data table ID constant, allowing you to continue to use the table in other instances.

If you attempt to remove a column name that does not match with a column on the table, a fix issues will be raised.

💡   Tip: Be aware that once the column is removed, the change is permanent.

Fields for this action

  • Data table ID

    • Select a table from a list of all tables available on your team. The list only includes tables you have permission to view.
      • You can also reference a table stored in a field. Change the left hand drop-down to Use table via field then select from any field that is part of the process. Learn more.
      • If necessary, you can enter the Table ID directly. Change the left hand drop-down to Use table by ID then enter the ID manually. Learn more.
  • Column name

    • The display name of the column header, in the regular Column Header format
  • Output Field Prefix

    • To help keep output fields organized, choose an output field prefix to add to the beginning of each output field name as this action may output more than one field.
    • The step’s name is used as the prefix by default.

What will this output?

This action may generate multiple fields. To help keep output fields organized, the prefix 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-prefix--output-field}}. Learn more

The expected output of this process is the column matching the Column name will be removed from the data table specified by the Data table ID. Additionally, there will be a field {output-prefix}--Column name that will return the number of the column that will be removed.

Sorry about that. What was the most unhelpful part?

Thanks for your feedback

We update the Help Center daily, so expect changes soon.

Link Copied

Paste this URL anywhere to link straight to the section.

Need more help?

If you're signed in to Catalytic Community, you can ask other users a question. You'll be redirected to Community where you can add more info.