Rename Columns

This action renames one or more columns in the input table and creates a new table with the new column names.
Best Practice: First try and rename the column in the SQL code before changing the name in this action.

This action executes a query against the input table and produces the matching rows and columns of the original table as the output.
This action works well for filtering rows. The inputs are queries by select from t1, t2, etc. This action uses more standard SQL syntax but requires more memory and a little more time to create a temporary table.

Caution

This action is not memory efficient because it makes a copy of the data, and the database is written in Java. This action uses twice the memory of unioning the tables.

  • Field

    Description
  • Label

    A label to identify the action. This label appears under the Action name inside the Action box. If this field is left blank, the default value is “Untitled.”
  • Description

    A brief explanation of what this action does inside the sequence. This description appears as a tooltip when your cursor hovers over the Action box.
  • Fail Message

    A message that identifies potential issues that could happen with this action. This fail message will appear if the action fails when you try generating the sequence. If this field is left blank, the default error message built into the action appears.
  • New Names
  • Column Name

    The name of the column.
  • New Name
    The new name of the column.