Transforms

The concept of a node is central to the data transformation process. Each node represents a specific data transformation action with its associated settings. Nodes are the building blocks of the data

Source and output transforms
Source
Adds outer dataset to the flow
​
Output
Saves the result of data flow in an outer dataset
​
Empty table
Adds empty table where users can manually add data
​
Chart
Show charts
​
Cleanup transforms
New Column
Adds a new column with “text”, number, or function
​
Change column type
Changes a data type for selected column(s)
​
Columns Edit
Renames, deletes and moves columns
​
If...Then
Adds a new column with a value based on the specified condition
​
Sort
Sorts a table by the specified column(s)
​
Filter
Filters rows based on the specified condition
​
Remove Duplicates
Removes duplicated rows
​
Split Text
Splits a column with the specified delimeter and returns the result in the new columns
​
Extract Text
Extracts the specified part of text into a new column(s)
​
Find and Replace
Finds and replaces the specified part of text
​
Match Text
Counts matches based on specified pattern in a column(s)
​
Rolling Functions
Calculates a window function operates on a group (“window”) of related rows
​
Nest
Creates Objects or Arrays in JSON format from the specified columns
​
Unnest
Flats Objects of Arrays in JSON format into columns or rows
​
Advanced transforms
Join
Joins 2 tables using the specified columns as keys
​
Union
Stacks rows of 2 or more tables
​
Group by
Groups rows and computes aggregate functions for the resulting group
​
Pivot
Creates new columns from values in the specified columns and computes aggregate functions as values for the new columns
​
Unpivot
Reshapes the data by merging one or more columns into key and value columns
​
AI transforms
Magic Column
Adds a new column based on GPT answer
​

Product overview - Previous

Tabula Use Cases

Source

Last modified 1mo ago