Tables: Rename a column

Use this action to update the display name of a column in a data table.

Use case

This action can be used on a commonly used data table to change column names in different situations. For example, update the column names to meet the standards required when uploading into other applications, or make column names more user friendly when outputting a data table to markdown in a customer email.

How to configure this action

Fields for this action

  • Data table

    • 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.
  • Current column name

    • The existing display name of the column in the data table to be renamed.
  • New column name

    • The updated display name for the existing column.
    • 💡   Tip: Column names should not contain line breaks or non-alphanumeric characters, including but not limited to ! % & () * ;
  • Output field name

    • The name of the field in which the result should be saved.

What will this output?

This action renames a column and outputs a field with the new column name. The table is saved to a field with the name defined in Output field name.

Output fields for this action

  • Output field name

    • The action will output the new column name chosen during configuration.

Get help with a problem or question

If something’s not working as expected, or you’re looking for suggestions, check through the options below.

Why do some column names not work?

Enclose individual column names and values in quotation marks (""), if they contain special characters like commas, leading/trailing whitespace, and newlines. For example:

  • If the column name is $Weekly Report,,,, enter the column name as "$Weekly Report,,,", with quotation marks.
  • If you want to use the field reference {{tablecolumn}} to dynamically reference the column name, enter it as "{{tablecolumn}}"

If the column name contains a quotation mark, escape each quotation mark with quotation marks, for example: if the column name is "Column name", enter it as """Column name""".

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.