When CSV data is read, the table defines the fields to read as input from the CSV file.
Enter the information for the Catalog Input step fields as shown in the following table.
| Column | Description |
|---|---|
| Name | The name of the field. |
| Type | The data type of the field. |
| Format | Enter the number format. See Number formats for a description of format symbols. |
| Position | The position is needed when processing the 'Fixed' Filetype. It is zero based, so the first character starts with position ‘0’. |
| Length |
The value of this field depends on the format:
|
| Precision |
The value of this field depends on the format:
|
| Currency | Used to interpret the symbol used to represent currencies (for example, $ or €). |
| Decimal | Used to represent a decimal point, either a dot '.' or a comma ',' (for example, 5,000.00 or 5.000,00). |
| Null if | Used to set as null (empty) if the string is equal to the specified value. |
| Default | Used to specify a default value to use in case the field in the CSV file was not specified (empty). |
| CatalogType | The data type as defined in Data Catalog. For example, UTF8. |
| Get Fields (button) | Click to retrieve a list of fields derived from the source file in Data Catalog. |
| Minimal width (button) | Click to minimize the field length by removing unnecessary characters. If selected, string fields will no longer be padded to their specified length. |