Fields

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: Number: Total number of significant figures in a number. String: Total length of string. Date: Length of printed output of the string (for example, `four` is a length for a year).
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.