Edit values node

Editing value is a basic action that you can perform on the data set. It lets you add a suffix, prefix, and replace values.

Node configuration

1. Double-click the Edit value node.
2. Click Add rule.
3. Select the columns which you want to include or exclude in the rule.
4. Select one of three options:
   • Add prefix - Adds a string to the beginning of every value in a column.
   • Add suffix - Adds a string to the end of every value in a column.
   • Replace - Searches values that match conditions and replaces these values with those you indicate or the values from a column you select.

   

5. To add more rules, click Add rule and repeat steps from 2 to 5.
6. Before you save the settings, you can check the preview of the file after changes in the Output data tab.
7. Confirm by clicking Apply.

Example of use

In example transformation +48 is removed from all values in a given column.

1. Start the transformation with the Data Input node.
2. Click the node.
3. Upload a sample file used to configure the transformation for later use and preview its results.
4. Confirm the configuration of the node by clicking Apply.
5. Add the Edit Values node.
6. Double-click the node.
7. Select the column to be transformed.
8. Replace all values that begin with +48 in the selected column with an empty value.
9. Confirm the changes by clicking Apply.
10. Add the Data Output node.
11. In the preview of the Data Output node, all values in the column that began with +48 are transformed and the +48 value was removed.