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.
- Select a table from a list of all tables available on your team. The list only includes tables you have permission to view.
-
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.
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.