The following scenario creates a two-component Job, which aims at reading each row of a file, selecting delimited data and displaying the output in the Run log console.
Drop a tFileInputDelimited component and a tLogRow component from the Palette to the design workspace.
Right-click on the tFileInputDelimited component and select Row > Main. Then drag it onto the tLogRow component and release when the plug symbol shows up.
Select the tFileInputDelimited component again, and define its Basic settings:
Fill in a path to the file in the File Name field. This field is mandatory.
If the path of the file contains some accented characters, you will get an error message when executing your Job. For more information regarding the procedures to follow when the support of accented characters is missing, see the Talend Installation and Upgrade Guide.
Define the Row separator allowing to identify the end of a row. Then define the Field separator used to delimit fields in a row.
In this scenario, the header and footer limits are not set. And the Limit number of processed rows is set on 50.
Set the Schema as either a local (Built-in) or a remotely managed (Repository) to define the data to pass on to the tLogRow component.
You can load and/or edit the schema via the Edit Schema function.
Related topics: see Talend Studio User Guide.
Enter the encoding standard the input file is encoded in. This setting is meant to ensure encoding consistency throughout all input and output files.
Select the tLogRow and define the Field separator to use for the output display. Related topic: tLogRow.
Select the Print schema column name in front of each value check box to retrieve the column labels in the output displayed.
Press Ctrl+S to save your Job.
Go to Run tab, and click on Run to execute the Job.
The file is read row by row and the extracted fields are displayed on the Run log as defined in both components Basic settings.
The Log sums up all parameters in a header followed by the result of the Job.