Fields tab

Microsoft Excel Output Fields tab

The Field tab defines properties for the exported fields. Click Get Fields to automatically retrieve a list of fields from the input stream and populate the list. The Minimal width button removes any padding from the output.

Option	Description
Name	Specify the name of the field.
Type	Specify the field's data type (string, date, or number).
Format	Specify the format mask (number type).
Get Fields (button)	Click Get Fields to retrieve a list of fields from the input stream and populate the list.
Minimal width (button)	Click Minimal width to remove any excess padding from the output.

Note: You can specify any format definitions available in Excel. These formats are not restricted to any Kettle-specific formatting.