Lookup Replace

Lookup Replace transformation function

CategoryTransformation Function
DescriptionThis function replaces keys with values inside text
PropertiesProperties are very similar to Lookup Transformation Function

Lookup Replace transformation function

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