Advanced-etl-processor
Lookup Replace
| Key | Value |
|---|---|
| Category | Transformation Function |
| Description | This function replaces keys with values inside text |
| Properties | Properties are very similar to Lookup Transformation Function |
To change Transformation function properties double click on it
Lookup replace does multiple replacements
For example
Input field value = 603
key = value
603 = 15195
195 = 501
- 603 is replaced with 15195
- Since 15195 has 195 inside it is replaced with 501
- The result is 15501
Video Tutorial
Back to Working with Transformer
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum
Last updated: August 1, 2022