Lookup Transformation Functions

Lookup transformation functions in Advanced ETL Processor allow you to find, match, replace, and enrich data using lookup values from mapping tables, files, or databases. Use these functions to perform value substitutions, pattern and range matching, key replacements, and SQL lookups as part of your data transformation process.

Download Advanced ETL Processor

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Lookup

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

Lookup Contains

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

Lookup RegEX

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

Lookup Replace

This function replaces keys with values

Range Lookup

This function finds a key for a given range

SQL Lookup

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

www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License