LOOKUP

Lookup a value in a non-related table or datasource.

Example Usage

LOOKUP('Departments') -> uses the incoming raw data value to lookup against Departments.Code
LOOKUP('Departments', value, 'Description') -> uses the incoming raw data value to lookup against Departments.Description
LOOKUP('Departments', SLICE(..), 'Code') -> uses another function (SLICE) to modify t

Overview

Function signature
LOOKUP(tablename, value, column, returncolumn)

Category
Database

Return data type
int

Arguments

Name	DataType	List Options	Description
tablename	string		The target table or datasource to search upon
value	string		The incoming value to use when searching on "column"
column	string		The column in the target table to search (defaults to "Code")
returncolumn	None		The column to return from the found record