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