Defining a component schema to read a delimited file

Defining the component schema of your delimited file helps you parse the data you are working with.

1. In the Designer, double-click the tFileInputDelimited component.
2. Click the […] button next to Edit schema.

   

   The Schema wizard opens.
3. Click the plus button to add a Column.
   1. Add as many columns as there are headers in your .csv file.
      Information noteNote: Headers are the first values in a .csv file.

      

   2. Enter the name of each Column.
      Column names must be identical to header names.

      Example

      • First
      • Last
      • Number
      • Street
      • City
      • State
   3. Select the Type of each Column.
      Information noteTip: Select the String Type for a postcode. A postcode number does not serve an arithmetic function.
4. Click OK.