-
From the main flow table, drop the directorID column onto the lookup table, in the Expr. key column of the id row.
This defines the column used to provide join keys.
-
On the lookup flow table, click the
button to open the setting panel in this table.
-
Click the Value column of the Lookup model row to display the [...] button and click this button to open the Options window.
-
Select Reload at each row and click OK to validate this choice.
-
Do the same in the Join model row to display
the corresponding Options window.
-
Select Inner Join to ensure that only the
matched records between the main flow and the lookup flow are outputted.
-
On the reject output flow table, click
the
button to open the setting panel.
-
In the Catch lookup inner join reject row,
click the Value column to display the [...] button and click this button to open the Options window.
-
Select true to send the records filtered out
by the inner join into the reject flow and
click OK to validate this choice.
-
Click Apply, then click OK to validate these changes and accept the
propagation prompted by the pop-up dialog box.