Configuring the components

Procedure

In the tFileList Basic settings view, browse to the directory, where the files to merge are stored.

The files are pretty basic and contain a list of countries and their respective score.
In the Case Sensitive field, select Yes to consider the letter case.
Select the tFileInputDelimited component, and display this component's Basic settings view.
Fill in the File Name/Stream field by using the Ctrl+Space bar combination to access the variable completion list, and selecting tFileList.CURRENT_FILEPATH from the global variable list to process all files from the directory defined in the tFileList.
Click the Edit Schema button and set manually the 2-column schema to reflect the input files' content.

For this example, the 2 columns are Country and Points. They are both nullable. The Country column is of String type and the Points column is of Integer type.
Click OK to validate the setting and accept to propagate the schema throughout the Job.
Then select the tUnite component and display the Component view. Notice that the output schema strictly reflects the input schema and is read-only.
In the Basic settings view of tLogRow, select the Table option to display properly the output values.

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!