# Main options tab

| Option                                               | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| ---------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Partition data over tables**                       | Select to split the data over multiple tables based on the value of the date field specified in the **Partitioning** field. When this option is selected, data is inserted into tables whose names follow the pattern `<target-table>_<date-format>`. These tables must be created manually before running the transformation in order for data to be inserted in these tables. See **Partition data per month**/**Partition data per day** for details on the date format.                                                                                                                                                                                                                                                                                                                                                               |
| **Partitioning field**                               | Specify the date field you want to use to determine how to split values across multiple tables. This value is used to generate a dated table name into which data will be inserted.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| **Partition data per month/ Partition data per day** | Determines the date format used in the table name when partitioning the table: `yyyyMM` for **Partition data per month** and `yyyyMMdd` for **Partition data per day**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| **Use batch update for inserts**                     | <p>Select to use batch inserts. This option groups <code>INSERT</code> statements, which limits round trips to the database. This option is enabled by default. The batch mode is only used when the following conditions are met:</p><ul><li>The <strong>Use batch update for inserts</strong> check box is selected.</li><li>The <strong>Commit Size</strong> option is greater than 0.</li><li>The <strong>Return auto-generated key</strong> option is cleared.</li><li>The transformation is not enabled to use unique connections (<strong>Transformation properties</strong> > <strong>Misc Tab</strong> > <strong>Make the transformation database transactional</strong>).</li><li>The database type supports batch updates.</li></ul><p>There are limiting factors depending on the database type and further step options.</p> |
| **Is the name of the table defined in a field?**     | Select to specify the name of the target table in the **Field that contains name of table**. This option allows you to store data from each row in a different table, based on the value of the **Field that contains name of table**. For example, if you store customer data in a field named `gender`, the data might end up in tables `Male` and `Female`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| **Field that contains name of table**                | Specify the field name to use for the name of the table when the option **Is the name of the table defined in a field?** is selected.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| **Store the table name field**                       | Select to store the table name in the output. When using this option, the table must contain a column with the name you defined in the **Field that contains name of table**.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| **Return auto-generated key**                        | Select to return the key that was generated by inserting a row into the table.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| **Name of auto-generated key field**                 | Specify the name of the new field in the output rows that contains the auto-generated key.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |


---

# 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/table-output/options-table-output/main-options-tab.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.