Setting the mapping conditions

Procedure

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.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!