Skip to main content Skip to complementary content

Step 1: Reading input data from a local file

You will use the tFileInputDelimited component to read the file customers.csv for the input data. This component can be found in the File/Input group of the Palette.

Procedure

  1. Drop a tFileInputDelimited component onto the design workspace, and double-click the to open the Basic settings view to set its properties.
    Screenshot of the component basic settings.
  2. Click the three-dot button next to the File name/Stream field to browse to the path of the input data file. You can also type in the path of the input data file manually.
  3. Click Edit schema to open a dialog box to configure the file structure of the input file.
  4. Click the plus button to add six columns and set the Type and columns names to the values listed in the following screenshot:
    The columns are defined as follows: a column id of type Integer, a column CustomerName of type String, a column CustomerAge of type Integer, a column CustomerAddress of type String, a column CustomerCity of type String, and a column RegisterTime of type Date.
  5. Click OK to close the dialog box.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here