Procedure
-
In the Repository tree view, expand
Metadata and the file node where you
have stored the input schemas and drop the relevant file onto the design
workspace.
The Components dialog box appears.
-
Select tFileInputDelimited from the list
and click OK to close the dialog
box.
The tFileInputDelimited component displays in the workspace. The input file used in this scenario is called ClientSample. It holds four columns including the two columns firstnameClient and lastnameClient we want to do the exact match on.
- Do the same for the second input file you want to use as a reference, ClientSample_Update in this scenario.
-
Drop the following components from the Palette onto the design workspace: tJoin, tFileOutputExcel,
and tFileOutputDelimited.
- Connect the main and reference input files to tJoin using Main links. The link between the reference input file and tJoin appears as a lookup link on the design workspace.
- Connect tJoin to tFileOutputExcel using the Main link and tJoin to tFileOutputDelimited using the Inner join reject link.