Field Replacer Processor
A field replacer allows you to replace a field value by providing a hard coded value e.g. null with “some value”, replace a value which is following a pattern by providing regex, and replace a field value by other field value or combination of field values.
You can replace input field if the regex pattern matches.
There are two option to provide values.
Value will be a combination (concatenation) of two columns.
Example: “JOBROLE” CONCAT “NAME”.
Order in which you select the columns will be considered for the combination.
Enter a single value to replace with.
Field Replacer Processor Configuration
To add a Field Replacer processor to your pipeline, drag the processor onto the canvas and right-click on it to configure as explained below:
| Field | Description |
|---|---|
| Output Field | Name of the output column, which is created or replaced by input values. |
| Value | The replacement value for matching regex pattern. |
| Regex Pattern | Regex pattern. |
| Input Field | Input column on which Regex should be applied. |
After configuring the component, detect the schema for desired result.
If you have any feedback on Gathr documentation, please email us!