Rename columns

Because the name of the columns are the key under which the data will be imported to Synerise or appear in the output file, you can change them to meet the requirements by using the Rename Column node.

Node configuration


  1. Click Add rule.
  2. Select one of the two available options:
    • Include these - it is a default option, if you leave it, all columns names you select will be renamed as you specify in the further configuration.
    • Include all except these - this option excludes renaming the columns you select.
  3. Click Add column.
  4. From the dropdown list, select the columns you want to rename.
  5. Under the Edit values by subheader, select one of the available options:
    • Adding prefix - adds a string to the beginning of the column name.
    • Adding suffix - adds a string to the end of a column name.
    • Replacing - finds values matching the conditions and replaces them with the value you specify. In the right field, enter the name you want to replace the original name with.
  6. To add more rules, click Add rule and repeat steps from 2 to 5.
  7. Before you save the settings, you can check the preview of the file after changes in the Output data tab.
  8. Confirm by clicking Apply.

Example of use


You can replace the email address column name with email, which is a required column name for Synerise imports. In result, the data from this column will be imported as the email attribute.

The sample file uploaded to the Input data node

name,surname,email_address
Dwight,Addams,dwight.addams@test.com
Martin,Smith,martin.smith@test.com
Kurt,Doe,kurt.doe@test.com

  1. As the first node add Data Input.
  2. In the configuration of the node, upload a sample file used to configure the transformation for later use and preview its results.
  3. As the next node, add a Rename column node.
  4. In the configuration of the node, change the column name from email_address to email.
    Example of use
    Changed name of the email address column
  5. As the last node, add Data Output.
    Result: You receive a data file.
😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker