# Transforms

### Source and output transforms

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Source</strong></td><td>Adds outer dataset to the flow</td><td></td><td><a href="/files/9wsooLNGtZNR78T20sxr">/files/9wsooLNGtZNR78T20sxr</a></td><td><a href="/pages/WgnHh23mscj6YZGTuE3K">/pages/WgnHh23mscj6YZGTuE3K</a></td></tr><tr><td><strong>Output</strong></td><td>Saves the result of data flow in an outer dataset</td><td></td><td><a href="/files/O6AIfQ8kNNgL4i4ZtLiY">/files/O6AIfQ8kNNgL4i4ZtLiY</a></td><td><a href="/pages/0Hgl21Io7LQyZ9KOzfrD">/pages/0Hgl21Io7LQyZ9KOzfrD</a></td></tr><tr><td><strong>Empty table</strong></td><td>Adds empty table where users can manually add data</td><td></td><td><a href="/files/ddVSddTlqvXMszcDhINo">/files/ddVSddTlqvXMszcDhINo</a></td><td><a href="/pages/mLOtLMY5Lv6CHpkqFqXs">/pages/mLOtLMY5Lv6CHpkqFqXs</a></td></tr><tr><td><strong>Chart</strong></td><td>Show charts</td><td></td><td><a href="/files/CNekNhY6Rs5M110el1jk">/files/CNekNhY6Rs5M110el1jk</a></td><td><a href="/pages/T3fllRuwGmXMkjUDTbPz">/pages/T3fllRuwGmXMkjUDTbPz</a></td></tr></tbody></table>

### Cleanup transforms

<table data-view="cards" data-full-width="false"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>New Column</strong></td><td>Adds a new column with “text”, number, or function</td><td></td><td><a href="/files/0sz4k0ycH8zBYGWRHgPM">/files/0sz4k0ycH8zBYGWRHgPM</a></td><td><a href="/pages/qgCmJVrLNCWykOEj76R6">/pages/qgCmJVrLNCWykOEj76R6</a></td></tr><tr><td><strong>Change column type</strong></td><td>Changes a data type for selected column(s)</td><td></td><td><a href="/files/N8IdqvwvLZRbIwwMkMiq">/files/N8IdqvwvLZRbIwwMkMiq</a></td><td><a href="/pages/GnqELalwD6jLe9AxYfdi">/pages/GnqELalwD6jLe9AxYfdi</a></td></tr><tr><td><strong>Columns Edit</strong></td><td>Renames, deletes and moves columns</td><td></td><td><a href="/files/q2kPsO4pJ2l5BCmqK0UT">/files/q2kPsO4pJ2l5BCmqK0UT</a></td><td><a href="/pages/Fnw1rECiTiGejppWJ7Co">/pages/Fnw1rECiTiGejppWJ7Co</a></td></tr><tr><td><strong>If...Then</strong></td><td>Adds a new column with a value based on the specified condition</td><td></td><td><a href="/files/Pc21BH1qoDVXxxHuIyFs">/files/Pc21BH1qoDVXxxHuIyFs</a></td><td><a href="/pages/lvf3SXBkAU0yQY65XdmZ">/pages/lvf3SXBkAU0yQY65XdmZ</a></td></tr><tr><td><strong>Sort</strong></td><td>Sorts a table by the specified column(s)</td><td></td><td><a href="/files/awJwCIgBV15GSjTjzuJC">/files/awJwCIgBV15GSjTjzuJC</a></td><td><a href="/pages/HKeNqCrNWfZF4cFXBRSN">/pages/HKeNqCrNWfZF4cFXBRSN</a></td></tr><tr><td><strong>Filter</strong></td><td>Filters rows based on the specified condition</td><td></td><td><a href="/files/Uyiu5MRkcuwOsNxK9gpk">/files/Uyiu5MRkcuwOsNxK9gpk</a></td><td><a href="/pages/N6lqlo52oMZxxgFiMVCc">/pages/N6lqlo52oMZxxgFiMVCc</a></td></tr><tr><td><strong>Remove Duplicates</strong></td><td>Removes duplicated rows</td><td></td><td><a href="/files/YkVRHZ0hHw71gxTsXMfg">/files/YkVRHZ0hHw71gxTsXMfg</a></td><td><a href="/pages/8uaLucUyJz4g4wlWLHY0">/pages/8uaLucUyJz4g4wlWLHY0</a></td></tr><tr><td><strong>Split Text</strong></td><td>Splits a column with the specified delimeter and returns the result in the new columns</td><td></td><td><a href="/files/nDBB7b6KvCsM9YTaWWx5">/files/nDBB7b6KvCsM9YTaWWx5</a></td><td><a href="/pages/ERUhieEis5D0DdZJmK3x">/pages/ERUhieEis5D0DdZJmK3x</a></td></tr><tr><td><strong>Extract Text</strong></td><td>Extracts the specified part of text into a new column(s)</td><td></td><td><a href="/files/qLJJ1EcjdlfG36OCpyAS">/files/qLJJ1EcjdlfG36OCpyAS</a></td><td><a href="/pages/tjowAC0eeRxOckn9OjPS">/pages/tjowAC0eeRxOckn9OjPS</a></td></tr><tr><td><strong>Find and Replace</strong></td><td>Finds and replaces the specified part of text</td><td></td><td><a href="/files/qcZDV0m7ZoUx0ZW8oHxc">/files/qcZDV0m7ZoUx0ZW8oHxc</a></td><td><a href="/pages/JZc9XQCutE2p27AK2R2u">/pages/JZc9XQCutE2p27AK2R2u</a></td></tr><tr><td><strong>Match Text</strong></td><td>Counts matches based on specified pattern in a column(s)</td><td></td><td><a href="/files/kntBahsLALtg3sWtcE9T">/files/kntBahsLALtg3sWtcE9T</a></td><td><a href="/pages/ZtlEWuMoepZryK9sjWeU">/pages/ZtlEWuMoepZryK9sjWeU</a></td></tr><tr><td><strong>Rolling Functions</strong></td><td>Calculates a window function operates on a group (“window”) of related rows</td><td></td><td><a href="/files/Y0blER2D4ta5KUFFQPww">/files/Y0blER2D4ta5KUFFQPww</a></td><td><a href="/pages/3SoAz0W8ZxvXgh3sgdQ4">/pages/3SoAz0W8ZxvXgh3sgdQ4</a></td></tr><tr><td><strong>Nest</strong></td><td>Creates Objects or Arrays in JSON format from the specified columns</td><td></td><td><a href="/files/KQKNCmKCEMOBvjH2u7Zj">/files/KQKNCmKCEMOBvjH2u7Zj</a></td><td><a href="/pages/WdcUcPtnDPdhdXKiCOtM">/pages/WdcUcPtnDPdhdXKiCOtM</a></td></tr><tr><td><strong>Unnest</strong></td><td>Flats Objects of Arrays in JSON format into columns or rows</td><td></td><td><a href="/files/jiirwCy5e8mdqahfG2x0">/files/jiirwCy5e8mdqahfG2x0</a></td><td><a href="/pages/Shugd9s1AJ8E3flHAqSI">/pages/Shugd9s1AJ8E3flHAqSI</a></td></tr></tbody></table>

### Advanced transforms

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Join</strong></td><td>Joins 2 tables using the specified columns as keys</td><td></td><td><a href="/files/VcUDOFFTK69jAPKFr2ge">/files/VcUDOFFTK69jAPKFr2ge</a></td><td><a href="/pages/I1pCeM12aDqupuck3DSv">/pages/I1pCeM12aDqupuck3DSv</a></td></tr><tr><td><strong>Union</strong></td><td>Stacks rows of 2 or more tables</td><td></td><td><a href="/files/8HjRMwOCuqfV41wv85wE">/files/8HjRMwOCuqfV41wv85wE</a></td><td><a href="/pages/IUQQv3hzMjo5GtZ021iU">/pages/IUQQv3hzMjo5GtZ021iU</a></td></tr><tr><td><strong>Group by</strong></td><td>Groups rows and computes aggregate functions for the resulting group</td><td></td><td><a href="/files/gZyJm5DmAqK2eYlJ5NoM">/files/gZyJm5DmAqK2eYlJ5NoM</a></td><td><a href="/pages/xilWRhWIU0jht5r8iMpa">/pages/xilWRhWIU0jht5r8iMpa</a></td></tr><tr><td><strong>Pivot</strong></td><td>Creates new columns from values in the specified columns and computes aggregate functions as values for the new columns</td><td></td><td><a href="/files/YK0yQhP8y49FmmcctYv7">/files/YK0yQhP8y49FmmcctYv7</a></td><td><a href="/pages/L7KQq6pYmDAezpnQRGYA">/pages/L7KQq6pYmDAezpnQRGYA</a></td></tr><tr><td><strong>Unpivot</strong></td><td>Reshapes the data by merging one or more columns into key and value columns</td><td></td><td><a href="/files/XhFdVSOiSE5iLb1LeDes">/files/XhFdVSOiSE5iLb1LeDes</a></td><td><a href="/pages/oI3KMyIahB4iTUGNW4CM">/pages/oI3KMyIahB4iTUGNW4CM</a></td></tr></tbody></table>

### AI transforms

<table data-view="cards" data-full-width="false"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Magic Column</strong></td><td>Adds a new column based on GPT answer</td><td></td><td><a href="/files/qKUo0CZiZYAL3S4KD1lo">/files/qKUo0CZiZYAL3S4KD1lo</a></td><td><a href="/pages/WgnHh23mscj6YZGTuE3K">/pages/WgnHh23mscj6YZGTuE3K</a></td></tr></tbody></table>


---

# 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.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.