This scenario describes a four-component Job aiming at matching the name column of an input flow with the reference index.
The output of this first name match is displayed in the FIRSTNAMEMATCH output column along with all other columns defined in the input schema of the tFirstnameMatch component.
To drop and link the components of interest, proceed as follows:
Drop the following components from the Palette to the design workspace: tFixedFlowInput, tFilterColumns, tFirstnameMatch and tLogRow.
Connect the first three components using Row > Main links.
Connect tFirstnameMatch to tLogRow using a Row > Output link.
To configure the input data, perform the following operations:
Double-click tFixedFlowInput to display the Basic settings view and define the component properties.
From the Schema list, set the schema type to Built-In and click the three-dot button next to Edit Schema. A dialog box displays.
Click the plus button to add as many lines as needed for the input schema you want to create from internal variables.
In this example, the input data flow is made of several columns including one for first names (name), two for country codes (iso2 and iso3) and one for gender (gender).
Click OK to close the dialog box.
The defined columns display in the Mode area of the component basic settings view.
In the Mode area, select the Use Inline Content (delimited file) option to display the corresponding view.
Set the row and field separators in the corresponding fields. You want to use these defined separators in your input flow.
In the Content area, type in the data for the input flow according to the schema you defined earlier.
To do this, you need to select the data columns of interest and then match them using tFirstnameMatch.
Click the tFilterColumns component to display its Basic settings view and define the component properties.
The tFilterColumns component enables you to build the output schema based on the column names of the input schema.
Click the three-dot button next to Edit schema to display a dialog box where you can define the output schema.
Select the name and gender columns from the input schema and move them to the output schema.
Click OK to validate your changes and close the dialog box.
Click tFirstnameMatch to display the Basic settings view and define the component properties.
If required, click the three-dot button next to Edit schema to view the input and output schemas, and then click OK to close the dialog box.
The output schema of this component is the same as the input schema plus one fixed column: FIRSTNAMEMATCH.