Dropping and linking the components
Procedure
- Drop two tFileInputDelimited components, a tJoin component, and two tLogRow components from the Palette onto the design workspace, and label them to better identify their roles in the Job, as shown above.
- Connect the tFileInputDelimited component labelled Main_Input to the tJoin component, which is labelled Check, using a Row > Main connection.
- Repeat the step above to connect the tFileInputDelimited component labelled Ref_Input to the tJoin component. This Row connection automatically appears as a lookup link.
- Connect the tJoin component to the tLogRow component labelled Matches using a Row > Main connection. This link will gather the data of the exact matches.
- Connect the tJoin component to the tLogRow component labelled Rejects using a Row > Inner join reject connection. This link will gather the rejected data.