> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-flows/tools-nodes.md).

# Tools (Nodes)

{% hint style="info" %}
Download our [cheatsheet](https://www.tabula.io/cheatsheet)
{% endhint %}

### Source and output transformations

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

### Search & Enrichment

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td></td><td><strong>Data Enrichment</strong></td><td>Enrich people &#x26; companies data with multi-providers</td><td><a href="/pages/x7VAaonKzFulDwsyKEcv">/pages/x7VAaonKzFulDwsyKEcv</a></td></tr><tr><td></td><td><strong>Search</strong></td><td>Coming soon...</td><td></td></tr><tr><td></td><td><strong>AI Research</strong></td><td>Coming soon...</td><td></td></tr></tbody></table>

### Cleanup transformations

<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><tr><td><strong>API Call</strong></td><td>Calls an external API and return a new column with answers</td><td></td><td><a href="/files/lDXNrVZ4XdkaG3u5gw4x">/files/lDXNrVZ4XdkaG3u5gw4x</a></td><td><a href="/pages/cb928qvomzJW1wWU8ZXg">/pages/cb928qvomzJW1wWU8ZXg</a></td></tr></tbody></table>

### Advanced transformations

<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 transformations

<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>AI 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><tr><td><strong>AI Table</strong></td><td>Creates a new table based on GPT prompt</td><td></td><td><a href="/files/22sb3t7rZHaC7JHw7IoB">/files/22sb3t7rZHaC7JHw7IoB</a></td><td><a href="/pages/dptDMQqurlCpaJbcTjhU">/pages/dptDMQqurlCpaJbcTjhU</a></td></tr></tbody></table>