Configuring Delimited Input Schema

You can configure a delimited input schema using Files for Unix and Windows Resource Configuration.

1. Configure attributes in the Input Delimited Record.
   For detailed information about these attributes, see Delimited Input Schema.
2. In the Attributes panel, click Add to add some fields.
   The name of the field is generated automatically as field, field1, field2 and so on. You can edit the field names. With the Add, Remove, Up and Down buttons, you can add or remove attributes, move attributes up and down.
3. For each field that you add, define the Type, Constant, and Use columns for the added fields.
   • Type

     The data type in the corresponding field in the file is converted before parsing.

     If you select the type as dateTime, specify the pattern and locale: right-click the field name, click Set locale and pattern, and then select a supported Locale and Pattern from the list.

   • Constant

     Enter a constant value for the appropriate field.

   • Use

     By default the Use column is selected. If the Use column is cleared, the selected field is not displayed in the output schema