Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference LOOKUP
Functions and Expressions Reference Guide
146
characters are needed.
LEFT can be used to return only the leftmost 10
characters.
Related Functions
RIGHT, MID, FIND
LOOKUP
The LOOKUP function sequentially searches a series, returning the first member of
the series that meets a specified condition.
Syntax
LOOKUP (series-object-expression , single-condition-
expression)
Meaning
LOOKUP (series_to_search , condition_to_evaluate)
Returns
This function returns a single-object.
Returns the first member of series_to_search for which condition_to_evaluate
evaluates to TRUE. Returns NONE, if no member of series_to_search meets the
condition specified by condition_to_evaluate.
Examples
LOOKUP (Account#:Customer , Company Name:Customer = "ACME")
This example returns the Account# of Customer whose Company Name is
ACME.
LOOKUP (Part#:Row:DBSelect , Model#:Row:DBSelect =
ModelCode:Legacy & Serial#:Row:DBSelect > "123")
This example returns the Part# of DBSelect where the Model# in that row
matches the ModelCode of Legacy and the Serial# is greater than 123.
Uses
Use
LOOKUP to find an occurrence of an object that meets a certain condition.