Skip to main content

Rename

Rename lets you change the name of datasets and columns.

Format

Rename has several formats:

  • Rename the column <column> to <new name>. Note that you can rename multiple columns in the same step by adding more <column> and <new name> parameters as a comma-separated list.
  • Rename the current dataset to <new name> (and perform disambiguate) (and mark it as transient)
  • Rename the dataset <dataset> <version> to <new name> (and force override) (and mark is as transient) (and perform disambiguate) (and use it).
  • Rename the datasets <dataset1> <version>, <dataset2> <version> to <dataset1 new name>, <dataset2 new name>. Note that you can rename multiple datasets in the same step by adding additional <datasetX> <version> and <datasetX new name>.

Parameters

Rename uses the following parameters:

  • dataset (required). The dataset to rename. Dataset names can contain up to and including 50 characters.
  • dataset1, dataset2 (required). The datasets to rename. Dataset names can contain up to and including 50 characters.
  • version (required only for renaming multiple datasets). The version of the specified dataset to rename.
  • column (required). The column you want to rename.
  • new name (required). The new name you want to use. Note that this string cannot contain spaces.

Output

If the dataset is successfully renamed, a new dataset loads with its new name. You can then refer to the dataset by its new name when you use other skills.

If the column is successfully renamed, a sample of the dataset is shown in the Data tab. You can then refer to a column by its new name when you use other skills.

Otherwise, an error message is shown.

Examples

To rename a column called "PClass" to the more readable “PassengerClass,” enter Rename the column PClass to PassengerClass.

To rename both the "PClass" column and the "Name" column in a single step, enter Rename the column Pclass to PassengerClass, Name to FullName.

To rename your current dataset to "MarketingData," enter Rename the current dataset to MarketingData.

To rename multiple datasets in a singular step, enter Rename the datasets Cust_Data, version 1, PoS_Data, version 2, Prod_Data, version 1 to CustomerData, SalesData, ProductData.