---
title: "ExportIntoTables"
slug: "exportintotables"
updated: 2023-11-15T15:45:12Z
published: 2023-11-15T15:45:12Z
canonical: "docs.datajet.app/exportintotables"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# ExportIntoTables

Exports a single source table into multiple sub tables using a dataset collection to determine records in each sub-table

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "ExportIntoTables" | Exports a single source table into multiple sub tables using a dataset collection to determine records in each sub-table |
| table | "prefix" | prefix for new table names. Can be blank. |
| dataSetCollection | "CollectionName" | Required. Data set collection containing the segments to use when exporting |
| append | false | false |
| dataSet | {} | Required. Source table dataset |
| fields[] |  | Field list to include in each sub-table. if omitted, all fields will be included. |

```json
{
  "method": "ExportIntoTables",
  "project": "",
  "table": "",
  "fields": [],
  "all": false,
  "exportTemplate": "",
  "template": "",
  "dataSet": {},
  "dataSetCollection": "",
  "append": false,
  "fastAppend": true,
  "optimize": true,
  "incremental": false,
  "ignoreIfNoRows": false,
  "abandonOnEmpty": false,
  "skipIfMissingSourceTable": false,
  "allowUnbalanced": false,
  "minDiscreteSize": 0,
  "adjustSymmetry": false,
  "ctod": false,
  "autoUseExtended": false
}
```

Additional keysExportIntoTables supports the same set of keys as [ExportIntoTable](/v1/docs/exportintotable) - with the addition of dataSetCollection.

*Added v5.11.4*

#### Approach

1. Create a dataset Collection for the table that is to be split into sub tables.  A sub-table will be created for each dataset in the collection.
2. *Optional - Create a field template*
3. Add the **ExportIntoTables** method to script
4. Drag the **source table** onto the ExportIntoTables method
5. Drag the dataset collection onto the ExportIntoTables method, or specify the **dataSetCollection** name
6. Specify the **table** prefix.    Each sub table will have the name "table" & "dataSetCollection itemname"
7. Specify the fields to include in the export (*to include all fields, use "*"*)

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1699106221055.png)