Configuring the components
Procedure
-
Double-click the tFileInputDelimited
component labelled Main_Input to display
its Basic settings view.
Information noteWarning:The dynamic schema feature is only supported in Built-In mode and requires the input file to have a header row.
-
Click Edit schema to define the schema
for this component.
In this use case, the main input file has five columns: FirstName, LastName, HouseNo, Street, and City. However, as we can leverage the advantage of the dynamic schema feature, we simply define two columns: one string type of column for the first names of people, and one dynamic column for the family information. To do so:
-
Select Dynamic from the Type list for the FamilyInfo column to retrieve the rest information
of each person on the name list: the last name, house number,
street, and city, which all together will identify a family.
-
Select Dynamic from the Type list for the FamilyInfo column to retrieve the rest information
of each person on the name list: the last name, house number,
street, and city, which all together will identify a family.
-
Double-click the tJoin component to open
its Basic settings view.
-
Click Edit schema to open the Schema dialog box to check the data structures
of the input files and define the data you want to pass to the output
components.
In this scenario, we want to pass both columns of the main input file, FirstName and FamilyInfo, to the output files, so simply copy the schema columns of the main input file by clicking the ->> button. Then, click OK to validate the schema and close the dialog box.
