Configuring the second subjob: reading and writing positional data
-
Double-click the tFileInputPositional
component to open its Basic settings
view.
Warning:The dynamic schema feature is only supported in Built-In mode and requires the input file
to have a header row. -
Select the Use existing dynamic check
box, and in from the Component List that
appears, select the tSetDynamicSchema
component you use to create the dynamic schema. In this use case, only one
tSetDynamicSchema component is used, so
it is automatically selected. -
In the File name/Stream field, enter the
path to the input positional file, or browse to the file path by clicking
the […] button. -
Fill in the Header, Footer and Limit fields
according to your input file structure and your need. In this scenario, we
only need to skip the first row when reading the input file. To do this,
fill the Header field with 1 and leave the other fields as they are.
-
Click the […] button next to Edit schema to open the [Schema] dialog box, define only one column, dyn in this example, and select Dynamic from the Type list. Then, click OK
to close the [Schema] dialog box and
propagate the changes.
-
Select the Customize check box, enter
'-'in the Padding char
field, and keep the other settings as they are. -
Double-click the tFileOutputPositional
component to open its Basic settings
view.
-
Select the Use existing dynamic check
box, specify the output file path, and select the Include header check box. -
In the Padding char field, enter
'so that the padding characters will be replaced with space in
'
the output file.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments