Procedure
-
Set Property Type to Repository since the file details are stored in
the repository. The fields to follow are pre-defined using the fetched
data.
The input file used in this scenario is called input. It is a text file that holds string, integer, and float java types.
Fill in all other fields as needed. For more information, see tFileInputDelimited. In this scenario, the header and the footer are not set and there is no limit for the number of processed rows. -
Click Edit schema to describe the data
structure of this input file. In this scenario, the schema is made of three
columns, StringtoInteger, IntegerField, and
FloatToInteger.
-
Double-click tConvertType to enter its
Basic settings view.
-
Click Edit schema to describe manually
the data structure of this processing component.
In this scenario, we want to convert a string type data into an integer type and a float type data into an integer type.Click OK to close the Schema of tConvertType dialog box. -
Double-click tMap to open the Map
editor.
The Map editor displays the input metadata of the tFileInputDelimited component
-
In the Map editor, drag each of the IntegerField and
the FloatToInteger rows from the input table to the
Sum row in the output table and click OK to close the Map editor.
