# Data Tables

{% hint style="info" %}
UPDATE: Data Tables is now a sub-menu item of Catalog. For more information, please see the release notes.
{% endhint %}

### What are Data Tables?

Data tables are CSV files uploaded to Threekit and converted into a database.

Data tables are useful for storing all data for the configurator, logic, and so forth within the Threekit system, eliminating the need for external tools or connections.

VERIFY:

Your CSV file must be of a "UTF-8 CSV" type to import properly.

### Adding a Data Table

&#x20;

Ensure the top row of your CSV file is the column header information before uploading.

Click "Data tables" in the left-hand menu.<br>

<figure><img src="/files/BKM9L0V9uvHD9lCiq4TJ" alt="" width="230"><figcaption></figcaption></figure>

In the upper right corner click "Import Table."<br>

Select the proper file from the popup window. In the new table window, name the table and select the appropriate data type for each column. Click "Create."

<img src="/files/TptwmstonHOVFTsbq4Q4" alt="" width="563">

The newly created data table will appear in the list.<br>

<figure><img src="/files/j7i7VN8HeDy6jLnr75qL" alt=""><figcaption></figcaption></figure>

Click on the table name to verify the information.

![](/files/aRsv3Nc3GepdSwM2iQRZ)

From this window,\
Click the "Rename" button to rename the table -- this does not modify the table data.<br>

Click "Download" to download a CSV copy of the table for editing.<br>

Click "Update" to upload a new file with adjusted information. NOTE: Any file may be used to update information, the file name does not need to match that of the previously uploaded file.<br>

New columns will be added to the column list. Adjust the data type as needed.

<img src="/files/uTqaMBTdXRBXoRi8YojE" alt="" width="563">

Removed columns will be noted with a warning message in red at the bottom.

<img src="/files/meG2gqoHWjOzHYNvwAyk" alt="" width="563">

Click update when finished.

### Using Data Tables in Catalog

In the catalog item edit screen, rules may use data table values as a source for attribute values.

<img src="/files/VlsHLN4hBaZsqTA9B186" alt="" width="563">

Add a rule to pull information from the database into the attribute value.

Set the rule name and conditions as usual. Click the "+" to add a "set attribute" action.

<img src="/files/3bVwCwAUw3zQyH7jMjUz" alt="" width="248">

Select the desired attribute from the drop down menu. (In this case SKU).\
Select "Database query."\
Select the desired data table.\
In "Select the first value from" choose the column name from the data table.\
Click "+ Add parameter." for each attribute whose value will originate from the data table.

Choose the desired column from the data table in the left-hand drop down.

<img src="/files/e7Gv5iaJtebvuc5sf4b1" alt="" width="435">

Select whether you want the value equal (=) or not equal (!=) to that found in the column.

<img src="/files/JvFDZzQpSsXFn5McOXOx" alt="" width="164">

In the right-hand drop down, select the attribute on the item whose value will be set.<br>

<figure><img src="/files/bHXlgBtG4rARsMoHSPoq" alt="" width="137"><figcaption></figcaption></figure>

![](/files/A3ezjhnNkHXIcLjlclwt)

NOTE:

The columns in your table may or may not match the names of your attributes. Name matching is not required.

Click "Done."

Don't forget to "Save Item!"

Test your configurator to ensure the value is properly updating.

<figure><img src="/files/4icczGKs0vrLtoJRrlU4" alt="" width="116"><figcaption></figcaption></figure>

### Video

{% embed url="<https://www.youtube.com/embed/2eerYmTodS4>" %}

&#x20;

**Data Tables trash** - you can now delete data tables you no longer need.<br>

<figure><img src="/files/U4GjpV3N5xgrbSr8QzeK" alt=""><figcaption></figcaption></figure>

You can `Go to trash` and restore deleted Data Tables:<br>

<figure><img src="/files/etgJ9Pm3ivRfoSgMaAKd" alt="" width="467"><figcaption></figcaption></figure>


---

# 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://community.threekit.com/learn/training/self-led-training/data-tables.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.
