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 labeled Main_Input to the tJoin component, which is labeled Check, using a Row > Main connection.
- Repeat the step above to connect the tFileInputDelimited component labeled Ref_Input to the tJoin component. This Row connection automatically appears as a lookup link.
- Connect the tJoin component to the tLogRow component labeled Matches using a Row > Main connection. This link will gather the data of the exact matches.
- Connect the tJoin component to the tLogRow component labeled Rejects using a Row > Inner join reject connection. This link will gather the rejected data.