Skip to main content
This gem runs in .

​
Overview

Use the MultiColumnRename gem to efficiently rename several columns in your dataset at the same time. This gem allows you to apply a consistent naming pattern by adding a prefix or suffix to selected columns, or perform advanced renaming using custom SQL expressions.
The gem has a corresponding interactive gem example. See Interactive gem examples to learn how to run sample pipelines for this and other gems.

​
Prerequisites

  • Add prophecy_basics package version 1.0.0 or higher to your project.

​
Parameters

​
Example

Assume you have the following table that includes the weather forecast for the next four days.
To standardize column names by converting them to lowercase, use the Advanced rename option in the MultiColumnRename gem with a custom SQL expression.
  1. Create a MultiColumnRename gem.
  2. Open the gem configuration and stay in the Visual view.
  3. Under Select columns to rename, select all columns.
  4. For the Rename method, choose Advanced rename.
  5. Click Select expression > Function.
  6. Search for and select the lower function.
  7. Inside of the lower function, click expr > Custom Code.
  8. Inside of the code box, write column_name. This applies the function to the column name.
  9. Click Done on the code box, and then click Save on your gem.

​
Result

After saving and running the gem, all selected columns will be renamed using the lower function. In this case, all column names will be lowercase in the output table.