This section provides information about the Lookup component.
Drag and drop the Lookup component on the canvas to lookup values from an
entity.
To position the component on the canvas, drag and move the component, or click
the component and use arrow keys on the keyboard to move it around.
The lookup component accepts input from two entities. One from the Value Entity
and the other from the Lookup Entity.
At any given time, right-click the component and select the relevant options to
either delink, remove inlinks or outlinks, or delete the component.
Double-click the lookup component to define a lookup condition. In the Lookup
window, you will see the connected entities on the left and right tabs.
You can drag the lookup entities on the right and left to reorder them.
To specify the lookup condition, the select a data element from the left,
select a a data element from the right and click = (Add Join). The lookup
condition is displayed at the bottom of the window. Do this for an many entities
on the left and right tabs you want to define.
To remove a lookup condition, select data elements from left and right entities
and click Remove Join.
Click Reset to reset the lookup condition.
Click Ok.
Note:
This creates a left outer
join between the connected entities.