You can specify what fields to read from your CSV file through the Fields table. Click Get fields to have the step populate the table with fields derived from the source file based on the current specified settings (such as Delimiter or Enclosure). All fields identified by this step are added to the table.
The table contains the following columns:
| Column | Description |
|---|---|
| Name | Name of the field. |
| Type | Type of field (either String, Date, or Number). |
| Format | An optional mask for converting the format of the original field. See Common Formats for information on common valid date and numeric formats you can use in this step. |
| Length |
The length of the field depends on the following field types:
|
| Precision | Number of floating point digits for number-type fields. |
| Currency | Symbol used to represent currencies ($5,000.00 or €5.000,00 for example). |
| Decimal | A decimal point can be a "." or "," (5,000.00 or 5.000,00 for example). |
| Group | A grouping can be a "," or "." (5,000.00 or 5.000,00 for example). |
| Trim Type | The trimming method to apply to a string. |
Click Preview to view the data coming from the source file.
See Understanding PDI data types and field metadata to maximize the efficiency of your transformation and job results.