Reading full rows in a delimited file
-
Create a new Job and add a tFileInputFullRow
component and a tLogRow component by typing their
names in the design workspace or dropping them from the Palette. -
Link the tFileInputFullRow component to the
tLogRow component using a Row > Main connection.
-
Double-click the tFileInputFullRow component to
open its Basic settings view on the Component tab.
-
Click the […] button next to Edit schema to view the data to be passed onto the
tLogRow component. Note that the schema is
read-only and it consists of only one column line.
-
In the File Name field, browse to or enter the
path to the file to be processed. In this scenario, it is E:/states.csv. -
In the Row Separator field, enter the separator
used to identify the end of a row. In this example, it is the default value
. -
In the Header field, enter 1 to skip the header row at the beginning of the
file. -
Double-click the tLogRow component to open its
Basic settings view on the Component tab.
In the Mode area, select Table (print values in cells of a table) for better readability of
the result. -
Press Ctrl+S to save your Job and then F6 to execute it.
As shown above, ten rows of data in the delimited file states.csv are read one by one, ignoring field separators, and the
complete rows of data are displayed on the console.To extract fields from rows, you must use tExtractDelimitedFields, tExtractPositionalFields, or tExtractRegexFields. For more information, see tExtractDelimitedFields, tExtractPositionalFields
and tExtractRegexFields.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments