# AI Table

## Overview

By adding AI Table Node, you can execute complex transformations over single or multiple tables with just a natural language prompt. It is a revolutionary productivity tool designed to simplify the creation of complex data transformations - it allows you to condense multiple transformation steps into a single node.

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

## Settings

#### Input nodes

Select the nodes you want to work with. The "+Add node" link allows you to add multiple nodes and select a node on the canvas.

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

Assign them custom names to make it simpler to refer to when constructing the prompt.

![](/files/WwzjECnVKDrgBjpN3IU2)

#### Prompt

Write your prompt in natural language to describe transformations you want to do over input datasets. You could mention the existing columns using `@` symbol.

{% hint style="warning" %}
AI doesn't know the data in the columns. It only knows the schemas of the selected nodes (column names and types) and one row of data. That means you cannot ask it to calculate results based on knowledge about values in the table. But you **can** ask anything if it can be done using standard functions.
{% endhint %}

Click the submit button<img src="/files/JxriEg9LOPE8yV2wn1Kx" alt="" data-size="line"> to send your prompt to AI.

AI returns a completely new table based on your request.

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

If AI returns incorrect results, try rewriting the prompt using more details. For example, you could specify the names of columns as context. You can also try different approaches to making a prompt to achieve the desired result.

### **What to ask**

* Any manipulation with input datasets such as join, group, summarize, filter, sort
  * Find the top 5 most active users by the number of events
  * Filter users with empty names
  * Return user numbers by country codes, filter top 10
  * Group users by industry
* As AI knows nothing about the data in the tables, it cannot answer the questions like:
  * Find negative reviews
  * Filter users with inactive status (for example, if the status can be “on hold”, “inactive”, “or removed” - all inactive - AI doesn't know that you need specifically mention all these statuses)
  * Find all users from NY (again, AI doesn't know the data in the city column and doesn't understand how to create a filter: “NY,” “New York,” “Apple City”)


---

# 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.tomat.ai/data-transformation/transforms/ai-table.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.