Rename Cols

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Rename Cols

Description

Rename column headers.

 

Example

Rename columns 'first' to 'First' and 'Last' to 'last':

 

hwo to rename columns transform example

 

Inputs

One.

 

Options

Change the column headers using the New name column.

Click Lower to change all the names in the New name column to lower case.

Click Upper to change all the names in the New name column to upper case.

Click Title to change all the names in the New name column to title case.

Click Replace to replace text in the New name column using text, exact text or Regular expression matching.

Click Reset to change all the names in the New name column back to their original name.

 

Notes

The names of column headers do not have to be unique.

Warnings are shown in the Info tab for duplicate column names (case sensitive).