Configuring the components

Procedure

If needed, double-click the main and reference input files to display their Basic settings views. All their property fields are automatically filled in. If you do not define your input files in the Repository, fill in the details manually after selecting Built-in in the Property Type field.
Double-click tJoin to display its Basic settings view and define its properties.
Click the Edit schema button to open a dialog box that displays the data structure of the input files, define the data you want to pass to the output components, three columns in this scenario, idClient, firstnameClient and lastnameClient, and then click OK to validate the schema and close the dialog box.
In the Key definition area of the Basic settings view of tJoin, click the plus button to add two columns to the list and then select the input columns and the output columns you want to do the exact matching on from the Input key attribute and Lookup key attribute lists respectively, firstnameClient and lastnameClient in this example.
Select the Inner join (with reject output) check box to define one of the outputs as inner join reject table.
Double-click tFileOutputExcel to display its Basic settings view and define its properties.
Set the destination file name and the sheet name, and select the Include header check box.
Double-click tFileOutputDelimited to display its Basic settings view and define its properties.
Set the destination file name, and select the Include header check box.

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