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