Skip to main content

Rename Transform

The Rename transform allows you to change the names of columns in your dataset. This is useful for standardizing column names, making them more descriptive, or preparing your data for specific analysis requirements.

Basic Usage​

To rename columns in your dataset:

  1. Select the Rename transform from the transform menu.
  2. For each column you want to rename: a. Choose the column from the "Select Column" dropdown. b. Enter the new name in the "Rename Column" input field.
  3. Apply the transformation.

Configuration Options​

Basic Options​

  • Select Column: Choose the column you want to rename.
  • Rename Column: Enter the new name for the selected column.
note

You can rename multiple columns in a single transformation by repeating the "Select Column" and "Rename Column" steps for each column you want to change.

caution

Avoid using periods (.) in your new column names, as they may cause issues with data display. If you include a period, it will be automatically replaced with a space.

Examples​

Here's an example of how to use the Rename transform:

Example: Standardizing Column Names

Input Dataset:

first_namelast_nameDOBphone_num
JohnDoe1990-01-011234567890
JaneSmith1985-05-159876543210

Configuration:

  • Select Column: first_name, Rename Column: FirstName
  • Select Column: last_name, Rename Column: LastName
  • Select Column: DOB, Rename Column: DateOfBirth
  • Select Column: phone_num, Rename Column: PhoneNumber

Result:

FirstNameLastNameDateOfBirthPhoneNumber
JohnDoe1990-01-011234567890
JaneSmith1985-05-159876543210
tip

When renaming columns, consider using a consistent naming convention across your dataset. This can make your data easier to understand and work with, especially in larger datasets.

Best Practices​

  1. Use Clear and Descriptive Names: Choose column names that clearly describe the data they contain. This makes your dataset more self-explanatory.

  2. Maintain Consistency: Use a consistent naming convention across all columns (e.g., CamelCase, snake_case, or PascalCase).

  3. Avoid Special Characters: Stick to letters, numbers, and underscores in column names to ensure compatibility with various data analysis tools.

  4. Document Changes: Keep a record of your column name changes, especially when working with large or complex datasets.

  5. Check Dependencies: If your data is used in other processes or reports, ensure that renaming columns won't break any downstream dependencies.

Troubleshooting​

  • If you don't see your changes reflected immediately, try refreshing your data view.
  • If a column name isn't updating as expected, check that you've selected the correct column in the "Select Column" dropdown.
  • Remember that column names must be unique. If you accidentally try to rename two columns to the same name, the transformation will fail.