Skip to main content Skip to complementary content

Step 1: Reading input data from a local file

We 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.
  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 what we listed in the following:
  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 – let us know how we can improve!

Leave your feedback here