Fields tab

Fields tab in S3 File Output

The Fields tab allows you to define the properties for the exported fields.

Column	Description
Name	Specify the name of the field.
Type	Select the field's data type from the dropdown list or enter it manually.
Format	Select the format mask (number type) from the dropdown list or enter it manually. See Common Formats for information on common valid date and numeric formats you can use in this step.
Length	Specify the length of the field, according to the following field types: Number Total number of significant figures in a number String Total length of the string Date Length of printed output of the string (for example, four is a length for a year)
Precision	Specify the number of floating point digits for number-type fields.
Currency	Specify the symbol used to represent currencies (for example, $ or €).
Decimal	Specify the symbol used to represent a decimal point, either a dot . or a comma , (for example, 5,000.00 or 5.000,00).
Group	Specify the method used to separate units of thousands in numbers of four digits or larger, either a dot . or a comma , (for example, 5,000 or 5.000).
Trim type	Select the trimming method to apply to a string, which truncates the field (none, left, right, both) before processing. Trimming only works when no field length is specified.
Null	Specify the string to insert into the output text file when the value of the field is null.
Get Fields (button)	Click to retrieve a list of fields from the input stream.
Minimal width (button)	Click to minimize the field length by removing unnecessary characters. If selected, string fields will no longer be padded to their specified length.

See [Understanding PDI data types and field metadata](../../../../Data%20Integration%20Perspective/Data%20Integration%20perspective%20in%20the%20PDI%20client/Advanced%20topics%20(PDI%20perspective)/Understanding%20PDI%20data%20types%20and%20field%20metadata.md) to maximize the efficiency of your transformation and job results.