Adds or removes a prefix to all input field names in the data.
If you are joining multiple data sources, you may want to add a prefix to help you to identify the data source or to avoid conflicting field definitions when joining data sets that contain identical field names.
To configure this node:
- In the Prefix property, enter the prefix that you want to add or remove.
- To add the prefix, set the Add property to True (this is the default).
To remove the prefix, set the Add property to False.
- If you want to add the prefix to input field names that already start with the specified prefix, set the Force property to True (in this case, the Add property must also be set to True).
Example
Adding a prefix
You have the following input data:
| Product_Codeunicode | Productunicode |
| 15 | Tea |
| 2 | Coffee |
| 3 | Water |
| 15 | Tea |
| 15 | Tea |
In the Prefix property, type:
PREFIX_
If the Add property is set to true and the Force property is set to default, the specified prefix is added to both input field names as follows:
| PREFIX_Product_Codeunicode | PREFIX_Productunicode |
| 15 | Tea |
| 2 | Coffee |
| 3 | Water |
| 15 | Tea |
| 15 | Tea |
Prefix is already used in one of the input field names
You have the following input data:
| Product_Codeunicode | PREFIX_Productunicode |
| 15 | Tea |
| 2 | Coffee |
| 3 | Water |
| 15 | Tea |
| 15 | Tea |
In the Prefix property, type:
PREFIX_
If the Add property is set to true and the Force property is set to default, the prefix is added to both column names, regardless of whether the input name already starts with the same prefix, as follows:
| Product_Codeunicode | PREFIX_PREFIX_Productunicode |
| 15 | Tea |
| 2 | Coffee |
| 3 | Water |
| 15 | Tea |
| 15 | Tea |
Removing a prefix
You have the following input data:
| Product_Codeunicode | PREFIX_Productunicode |
| 15 | Tea |
| 2 | Coffee |
| 3 | Water |
| 15 | Tea |
| 15 | Tea |
In the Prefix property, type:
PREFIX_
If the Add property is set to false and the Force property is set to default, the prefix is removed from the Product column, as follows:
| Product_Codeunicode | Productunicode |
| 15 | Tea |
| 2 | Coffee |
| 3 | Water |
| 15 | Tea |
| 15 | Tea |
Properties
Prefix
Specify the prefix that you want to add or remove. A value is required for this property.
Add
Optionally specify whether to add the specified prefix to the input field names. If set to false, the specified prefix is removed from the input field names. The default value is True.
Force
Optionally specify whether to add the specified prefix to the input field names even if the field already starts with the prefix (if the Add property is also set to true).
The default value is False.
Inputs and outputs
Inputs: in1.
Outputs: out1.