Fields tab

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
The Fields tab is where you define properties for the fields being exported. The following table describes each field:
Field Description
Name The name of the field
Type Type of the field can be either String, Date or Number.
Format An optional mask for converting the format of the original field.
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 period (.) as in 10,000.00 or it can be a comma (,) as in 5.000,00.
Group A grouping can be a comma (,) as in 10,000.00 or it can be a period (.) as in 5.000,00.
Trim Type The trimming method to apply to a string. Trimming only works when no field length is specified.
Null If the value of the field is null, the specified string is inserted into the output text file.