Lookup Details

Element Details: Lookup

Available in: Logi Info

Source code name: Lookup

Introduced in: v10.1.18

The Lookup element runs the child DataLayer once for each row in the parent DataLayer and joins the results together. Unlike a standard Join element, a Lookup element does not require that all of the target data is downloaded prior to the join. This is ideal when trying to join small data sets to very large data sets.

Use @Data tokens in child elements to specify query/search values from the parent DataLayer’s rows.

Element Group:Merge and Join

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

UserDefined

The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

IncludeCondition

True

False

An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.