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.
- Click Add rule.
- 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.
- Click Add column.
- From the dropdown list, select the columns you want to rename.
- 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.
- To add more rules, click Add rule and repeat steps from 2 to 5.
- Before you save the settings, you can check the preview of the file after changes in the Output data tab.
- Confirm by clicking Apply.
Example of use
You can replace the
email address column name with
name,surname,email_address Dwight,Addams,email@example.com Martin,Smith,firstname.lastname@example.org Kurt,Doe,email@example.com
- As the first node add Data Input.
- In the configuration of the node, upload a sample file used to configure the transformation for later use and preview its results.
- As the next node, add a Rename column node.
- In the configuration of the node, change the column name from email_address to email.
- As the last node, add Data Output.
Result: You receive a data file.