# 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="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/tH07mg6tsrD41y3bM10V/Source.png">Source.png</a></td><td><a href="transforms/use-ai">use-ai</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/pOmDe99FDFiIGoFQSbzK/Output.png">Output.png</a></td><td><a href="transforms/output">output</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/qan288LhvKClfe2bkSik/BlankTable.png">BlankTable.png</a></td><td><a href="transforms/new-empty-table">new-empty-table</a></td></tr><tr><td><strong>Chart</strong></td><td>Show charts</td><td></td><td><a href="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/VDpi4NPY5xxymuh8aV2B/Chart_.png">Chart_.png</a></td><td><a href="transforms/chart">chart</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="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/gK3SBd7JZFSyts4A6kYy/New%20column.png">New column.png</a></td><td><a href="transforms/new-column">new-column</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/BwcWvRQxZFOsLF8IuqxX/Type.png">Type.png</a></td><td><a href="transforms/column-type">column-type</a></td></tr><tr><td><strong>Columns Edit</strong></td><td>Renames, deletes and moves columns</td><td></td><td><a href="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/GRniWRSIsYx9GPPjDRNa/Edit.png">Edit.png</a></td><td><a href="transforms/columns-edit">columns-edit</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/CqVZDgSjwkAeBF7voLYg/If.png">If.png</a></td><td><a href="transforms/if...then">if...then</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/zRJzjSH4z9zC9fsewplf/Sort.png">Sort.png</a></td><td><a href="transforms/sort">sort</a></td></tr><tr><td><strong>Filter</strong></td><td>Filters rows based on the specified condition</td><td></td><td><a href="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/YvTiAvlWJxFl2KTObXWt/Filter.png">Filter.png</a></td><td><a href="transforms/filter">filter</a></td></tr><tr><td><strong>Remove Duplicates</strong></td><td>Removes duplicated rows</td><td></td><td><a href="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/xgNCapckn5HE3OFfmQ35/Remove%20Duplicates.png">Remove Duplicates.png</a></td><td><a href="transforms/remove-duplicates">remove-duplicates</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/CRGQJytNDoPvXDLzgtVu/Split.png">Split.png</a></td><td><a href="transforms/split-text">split-text</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/ksyzxd3N6eqRRFVzsIy6/Extract.png">Extract.png</a></td><td><a href="transforms/extract-text">extract-text</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/aau81hvMRBdHXLEMSvqg/Replace.png">Replace.png</a></td><td><a href="transforms/find-and-replace-text">find-and-replace-text</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/ON6QDIhcVvF3dQT7kRhq/Match.png">Match.png</a></td><td><a href="transforms/match-text">match-text</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/0T86lr2qtdi5ZjpLk9df/Rolling.png">Rolling.png</a></td><td><a href="transforms/rolling-functions">rolling-functions</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/Um6FGBDs5bGlrYoutczB/Nest.png">Nest.png</a></td><td><a href="transforms/to-json">to-json</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/9MuZAP3bLD6aZckhs6gN/Unnest.png">Unnest.png</a></td><td><a href="transforms/from-json">from-json</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="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/nEAZQ2MH1hyKnW87hQ1o/Join.png">Join.png</a></td><td><a href="transforms/join">join</a></td></tr><tr><td><strong>Union</strong></td><td>Stacks rows of 2 or more tables</td><td></td><td><a href="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/iA5650g2Tn1HTonbt830/UnionN.png">UnionN.png</a></td><td><a href="transforms/union">union</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/JX5nGUoNBr1Gjo1qZdWR/Groupby.png">Groupby.png</a></td><td><a href="transforms/group-by">group-by</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/FkO8yaT9lftBsoGDt9yu/Pivot.png">Pivot.png</a></td><td><a href="transforms/pivot">pivot</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://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/aRGUbgYnYVVtm322Hvmj/UnPivot.png">UnPivot.png</a></td><td><a href="transforms/unpivot">unpivot</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="https://content.gitbook.com/content/sZmcXPVeWeMtjkE1uRh9/blobs/HFgFyfRhdshK2vzcbdgv/Magic.png">Magic.png</a></td><td><a href="transforms/use-ai">use-ai</a></td></tr></tbody></table>
