Lookup Transformation Functions

This function substitutes values using mapping table. The mapping table can be populated manually or loaded from file/database

Checks if key exists inside the input value and if it is returns matching value

Checks input value matches regular expression and if it is returns matching value

This function replaces keys with values

This function finds a key for a given range

Retrieves values from the database using SQL. Parameters are replaced with actual values before the execution