# Fields table

The fields in this table define the properties for each new field created by the split. For each new field, you must define the **New field** name, **Type**, and other properties.

| Field          | Description                                                                                                                                                                                                                                                                                                                 |
| -------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **New field**  | Specify the name of the new field created by the split.                                                                                                                                                                                                                                                                     |
| **ID**         | Specify an identifier string in the field. If you specify an ID that does not match the existing ID in the field, the resulting field value is null.                                                                                                                                                                        |
| **Remove ID?** | Specify an ID to remove from the field in the output.                                                                                                                                                                                                                                                                       |
| **Type**       | Select the field's data type from the drop-down list or enter it manually.                                                                                                                                                                                                                                                  |
| **Length**     | Specify the length of the field.                                                                                                                                                                                                                                                                                            |
| **Precision**  | Specify the number of floating point digits for number type fields.                                                                                                                                                                                                                                                         |
| **Format**     | Select the format mask (number type) from the drop-down list or enter it manually. See [Common Formats](https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/pdi-transformation-steps-reference-overview/common-formats) for information on common valid date and numeric formats you can use in this step. |
| **Group**      | Specify the method used to separate units of thousands in numbers of four digits or larger, either a comma (,) as in 10,000.00 or a dot (.) as in 5.000,00.                                                                                                                                                                 |
| **Decimal**    | Specify the symbol used to represent a decimal point, either a dot (.) as in 10,000.00 or a comma (,) as in 5.000,00.                                                                                                                                                                                                       |
| **Currency**   | Specify the symbol used to represent currencies. For example, $ or €.                                                                                                                                                                                                                                                       |
| **Nullif**     | Specify a string to match in the field. When the field value matches the specified string, the field value is set to null.                                                                                                                                                                                                  |
| **Default**    | Specify the default value of the field if it is null or empty.                                                                                                                                                                                                                                                              |
| **Trim Type**  | Select the trimming method (none, left, right, or both) to apply to a string if truncating the field before processing. Trimming only works when no field length is specified.                                                                                                                                              |

See [Understanding PDI data types and field metadata](https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/data-integration-perspective-in-the-pdi-client/advanced-topics-pdi-perspective/understanding-pdi-data-types-and-field-metadata) to maximize the efficiency of your transformation and job results.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/pdi-transformation-steps-reference-overview/split-fields/fields-table-split-fields-step.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.