# 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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FsGcZu68LEKm6napiW9DY%2FSource.png?alt=media&#x26;token=c08364b9-2a8f-49b3-9f48-278131f659af">Source.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FIa4sKi2AEtO0ss33y7ap%2FOutput.png?alt=media&#x26;token=e402045b-c52e-465b-9fda-f8e44f54fac5">Output.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FOhypXBUwBzxM6HWDGulD%2FBlankTable.png?alt=media&#x26;token=1d3f0900-ebd5-4ca1-bbe5-ddb03d8d0f6d">BlankTable.png</a></td><td><a href="broken-reference">Broken link</a></td></tr><tr><td><strong>Chart</strong></td><td>Show charts</td><td></td><td><a href="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FTdUvtwe4Ddhs6U1XPWhV%2FChart_.png?alt=media&#x26;token=9496f556-58a7-412d-81f0-e8a06c710908">Chart_.png</a></td><td><a href="broken-reference">Broken link</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="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FmgImDNZ72Z0IS7XV9hla%2FNew%20column.png?alt=media&#x26;token=19f4c600-b7b0-4f6d-93d7-7faf771cab46">New column.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FersgDE2aG9Vz1KYPb0Zq%2FType.png?alt=media&#x26;token=65299edc-13ac-424a-8e99-f138ef85d669">Type.png</a></td><td><a href="broken-reference">Broken link</a></td></tr><tr><td><strong>Columns Edit</strong></td><td>Renames, deletes and moves columns</td><td></td><td><a href="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FhP0LWGSP7aDFs2xHC2P6%2FEdit.png?alt=media&#x26;token=63fa7742-78b8-4909-b68d-5838bf100649">Edit.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FFIfrxnqzPg40m68Ji56D%2FIf.png?alt=media&#x26;token=ce7b9257-cf00-4cc4-ad75-dbeb4f1f21e3">If.png</a></td><td><a href="broken-reference">Broken link</a></td></tr><tr><td><strong>Sort</strong></td><td>Sorts a table by the specified column(s)</td><td></td><td><a href="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2Fyg1qjqjUIKT9g0KB770F%2FSort.png?alt=media&#x26;token=73cd8095-3ca4-4cb2-ab8f-81efe823a19a">Sort.png</a></td><td><a href="broken-reference">Broken link</a></td></tr><tr><td><strong>Filter</strong></td><td>Filters rows based on the specified condition</td><td></td><td><a href="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FniU1suGYnqmuAOAvZV06%2FFilter.png?alt=media&#x26;token=70e3852e-c360-4832-ae25-e56ac6c98f19">Filter.png</a></td><td><a href="broken-reference">Broken link</a></td></tr><tr><td><strong>Remove Duplicates</strong></td><td>Removes duplicated rows</td><td></td><td><a href="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FeNTJY1UlFfSnJEhmBPVw%2FRemove%20Duplicates.png?alt=media&#x26;token=01979c5a-b529-4453-ba36-846f340a7c2a">Remove Duplicates.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FUYW2B1uGAqI2CY0T6Bkm%2FSplit.png?alt=media&#x26;token=6cda8f7d-4237-4998-a613-a814fbc8595c">Split.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2Fh8BMmTtBE5R7tlNcMhpw%2FExtract.png?alt=media&#x26;token=d64b690f-a015-43d5-943f-f0625e8ef9a4">Extract.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FTCeFGJMA6rv9UrJ2Pw9j%2FReplace.png?alt=media&#x26;token=c50c1e74-0439-41ae-8732-d2ad3b98c323">Replace.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FxMPNxSqfLTbnr8X6cxff%2FMatch.png?alt=media&#x26;token=d21cd0d3-43a1-40e4-a1a8-30ab7f042b52">Match.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FINGRboer7Q6TmZHj8cIP%2FRolling.png?alt=media&#x26;token=ad505f3a-c8a8-41f7-92bf-bd548bc4f466">Rolling.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FhR6nbgWHTO0ybQxfY2ok%2FNest.png?alt=media&#x26;token=77aaa60c-a069-48b3-a08c-f5b84ccb47d7">Nest.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FaReFI33tS1gvzuSAXlNM%2FUnnest.png?alt=media&#x26;token=47f2cad6-697c-418e-b891-f18585780a8e">Unnest.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FMwRIsz0OIjU3qCvCoy72%2FAPI.png?alt=media&#x26;token=5a7d13db-f708-4cf0-8d87-02579793cb2b">API.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2Fu064Ph6l90QMC8xG0V9A%2FJoin.png?alt=media&#x26;token=a1ba7500-4883-4561-a57c-201570ad4596">Join.png</a></td><td><a href="broken-reference">Broken link</a></td></tr><tr><td><strong>Union</strong></td><td>Stacks rows of 2 or more tables</td><td></td><td><a href="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2Fdby6aeiK7McxkAbopUJo%2FUnionN.png?alt=media&#x26;token=4ad2e05c-d90d-4b7c-a053-0b0913d8728e">UnionN.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FNN2L0pqiDvW2UC48Ap8Z%2FGroupby.png?alt=media&#x26;token=1fd697b6-ab8e-42fd-be91-6c4c3e489e24">Groupby.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FTo6MPR77HMpEf5a8Afyb%2FPivot.png?alt=media&#x26;token=b4f6e842-2ed4-410f-8276-cf7d3c31024a">Pivot.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2F5KM5jh88wcIxTmacs7Ge%2FUnPivot.png?alt=media&#x26;token=2d6adc30-ca1b-4346-8a45-e9ec06787456">UnPivot.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2FfHU9NqmojTcUR9NPCagI%2FMagic.png?alt=media&#x26;token=a96248ac-5eb5-4829-8133-d30eaf1c0172">Magic.png</a></td><td><a href="broken-reference">Broken link</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="https://3263174655-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ft2TZFevDoRrOBI2rPK1p%2Fuploads%2F0XkxDUhtCWOB1Ii1WyfK%2FAITable.png?alt=media&#x26;token=3890959a-d150-4a8f-bd29-0bbe74f3b360">AITable.png</a></td><td><a href="broken-reference">Broken link</a></td></tr></tbody></table>