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.