Functions

LOOKUPB

Lookup a value from Data Source B. This is functionally equivalent to LOOKUPA except that it uses Data Source B (Target) as the connection.

Syntax

object LOOKUPB(string column, FROM(from), keyValue)
object LOOKUPB(string columnName, LFROM from, params KVAL[] keyValues)

Example

Lookup via Data Source (B) the accountid from account where name equals the Name column.

LOOKUPB("accountid", "account", WHEN("name", Name))