Rename Columns

Renames and specifies the type of one or more columns.

Example

name	city
James	London
Jane	Paris

→

first_name	birth_location
James	London
Jane	Paris

Configuration

The following option(s) are available when configuring this transform.

Column

Specify which columns to rename. You can choose All Columns or select specifc columns.

Columns

Specify the name and data type for each column. You can only select data types that match the data in the sample.

Note

Use the searchbox to filter column names.

Screenshot of rename columns configuration

Key Considerations

See Promote row to header for details about which characters are valid for column names.
The Wide Integer type is deprecated, and scripts that’s use this type are not supported by API v2 endpoints. We recommend using DECIMAL(20,0) instead.

Promote Row to Header Replace Substring