Dataflow Reference

Discover tools available in dataflows, automations and visualizations.

Data processing building blocks

Toric is a visual data experience – from exploration, processing and visualization. Nodes can be connected together to build powerful data-pipelines.
Extracts a set of columns from the input table.

Breakout

Extracts a set of columns from the input table.

Trim white spaces, and remove blank rows or non-printable characters in table rows.

Clean Up

Trim white spaces, and remove blank rows or non-printable characters in table rows.

Combine one or many columns based on the first non-empty value.

Coalesce

Combine one or many columns based on the first non-empty value.

Rename one or more columns in a table, modifying the display names.

Column Rename

Rename one or more columns in a table, modifying the display names.

Create a new column and tag data based on a set of rules.

Data Tagging

Create a new column and tag data based on a set of rules.

Identify changes in data between two source versions.

Diff

Identify changes in data between two source versions.

Select and create a copy of any column in your data.

Duplicate Column

Select and create a copy of any column in your data.

Change the column type or name of one or more columns.

Edit Column

Change the column type or name of one or more columns.

Gives the position (index) of a value in a table.

Element At Index

Gives the position (index) of a value in a table.

Outputs the position (index) of a value in a table.

Element Index

Outputs the position (index) of a value in a table.

Filters data based on the configuration.

Filter

Filters data based on the configuration.

Provides the index of a specific value (opposite to ElementAtIndex).

Index Of Element

Provides the index of a specific value (opposite to ElementAtIndex).

Keep rows at the top or bottom of a table.

Keep Rows

Keep rows at the top or bottom of a table.

Promotes the next row of a table as the new headers and inference types.

Promote Headers 

Promotes the next row of a table as the new headers and inference types.

Displays all the rows between two rows indexes.

Range Selector

Displays all the rows between two rows indexes.

Remove rows from the top or bottom of a table.

Remove Columns

Remove rows from the top or bottom of a table.

Remove rows from the top or bottom of a table.

Remove Rows

Remove rows from the top or bottom of a table.

Reorders columns in a table relative to other columns.

Reorder Columns

Reorders columns in a table relative to other columns.

Sort table records in ascending or descending order based on selected fields.

Sort

Sort table records in ascending or descending order based on selected fields.

Takes several characters from the left or right side of the text as a new column.

Text Truncate

Takes several characters from the left or right side of the text as a new column.

Translate an array of columns into a set of records.

Unnest

Translate an array of columns into a set of records.

Append rows from two different sources, sharing columns with the same name and type.

Append

Append rows from two different sources, sharing columns with the same name and type.

Combine columns by merging column values into a single value.

Combine Columns

Combine columns by merging column values into a single value.

Concatenates two tables as a single table, merging the columns of the two tables.

Concatenate

Concatenates two tables as a single table, merging the columns of the two tables.

Remap data from existing fields into a new data structure.

Data Mapper 

Remap data from existing fields into a new data structure.

Replaces the value of a cell by searching and matching conditions.

Find and Replace

Replaces the value of a cell by searching and matching conditions.

Groups table records based on the selected fields.

Group By

Groups table records based on the selected fields.

Combine columns, entire tables, or both by joining them by columns and direction selected.

Join

Combine columns, entire tables, or both by joining them by columns and direction selected.

Flip and summarize data by transforming columns to rows.

Pivot

Flip and summarize data by transforming columns to rows.

Outputs the row at a specific index in a table.

Place As Index

Outputs the row at a specific index in a table.

Selects and copies a specific column from a table.

Pluck Column

Selects and copies a specific column from a table.

Find and extract data using regular expression.

ReGex Extract

Find and extract data using regular expression.

Find and replace data using regular expression.

ReGex Replace

Find and replace data using regular expression.

Displays appended copies of the input value.

Repeat

Displays appended copies of the input value.

Splits a column into multiple columns using a delimiter value.

Split

Splits a column into multiple columns using a delimiter value.

Stack data from the same source by a selected column.

Stack

Stack data from the same source by a selected column.

Combines two columns together into a new column.

String Concatenate

Combines two columns together into a new column.

Creates a new table of summarized values, preserving groups.

Summarize

Creates a new table of summarized values, preserving groups.

Flip data along it's diagonal turning columns to rows.

Transpose

Flip data along it's diagonal turning columns to rows.

Remove record groups by flattening the table.

Ungroup

Remove record groups by flattening the table.

Extracts the distinct values from input data.

Unique

Extracts the distinct values from input data.

Generates a true or false value that is constant.

Boolean

Generates a true or false value that is constant.

Generates a value of currency respecting the localization settings.

Currency

Generates a value of currency respecting the localization settings.

Generates a Date value that is constant.

Date

Generates a Date value that is constant.

Generates a unit of measure in feet. Use this node to create a constant value.

Feet

Generates a unit of measure in feet. Use this node to create a constant value.

A number that can be changed into a decimal (float), integer, or an unassigned integer.

Number

A number that can be changed into a decimal (float), integer, or an unassigned integer.

Produces a random number that regenerates every time the node is evaluated.‍

Random Number

Produces a random number that regenerates every time the node is evaluated.‍

Produces a random number that remains the same regardless if the node is re-evaluated.

Stable Random

Produces a random number that remains the same regardless if the node is re-evaluated.

An editable text field that can be changed.

Text

An editable text field that can be changed.

A Generate node that shows the Time Now

Time Now

A Generate node that shows the Time Now

Generates a unit of measurement in high precision.

Unit

Generates a unit of measurement in high precision.

Converts any negative number into positive number.

Absolute

Converts any negative number into positive number.

Add two single numbers or two columns of any number type.

Add

Add two single numbers or two columns of any number type.

Calculates the average of numbers in a column.

Average

Calculates the average of numbers in a column.

Rounds the input number to the highest integer number closest to the input.

Ceiling

Rounds the input number to the highest integer number closest to the input.

Get a list of column names in your data.

Column Names

Get a list of column names in your data.

A function that provides the length of the adjacent side divided by the hypotenuse length.

Cosine

A function that provides the length of the adjacent side divided by the hypotenuse length.

Calculates the number of rows in a table.

Count

Calculates the number of rows in a table.

Divide two single numbers or two columns of any number type.

Divide

Divide two single numbers or two columns of any number type.

Adds new columns with results calculated from other columns.

Field Calculator

Adds new columns with results calculated from other columns.

Rounds the input number to the lowest integer number closest to the input.

Floor

Rounds the input number to the lowest integer number closest to the input.

Type formulas using data fields to calculate new values.

Formula

Type formulas using data fields to calculate new values.

Calculates the number of groups in a table.

Group Count

Calculates the number of groups in a table.

Returns the maximum value of the selected number column in the input.

Max

Returns the maximum value of the selected number column in the input.

Returns the minimum value of the selected number column in the input.

Min

Returns the minimum value of the selected number column in the input.

Multiply two single numbers or two columns of any number type.

Multiply

Multiply two single numbers or two columns of any number type.

Replaces the input number with the nearest integer number.

Round

Replaces the input number with the nearest integer number.

Provides the input number of a ratio between the long side (hypotenuse) and the side that is counter to an acute angle in a right triangle.

Sine

Provides the input number of a ratio between the long side (hypotenuse) and the side that is counter to an acute angle in a right triangle.

Subtract two single numbers or two columns of any number type.

Subtract

Subtract two single numbers or two columns of any number type.

Adds all the values in a column with the total value.

Sum

Adds all the values in a column with the total value.

Output is true if the value of input A is bigger than the value of input B.

Bigger Than

Output is true if the value of input A is bigger than the value of input B.

Evaluates if the condition of an input value is true or false.

If

Evaluates if the condition of an input value is true or false.

Output is true if the value of inputA and inputB are the same.

Is Equal

Output is true if the value of inputA and inputB are the same.

Output is true if the value of inputA is less than the value of inputB.

Less Than

Output is true if the value of inputA is less than the value of inputB.

Coming Soon

Get started today

Start a trial to access Toric and build a data pipeline in minutes.

Dataflow Reference

Discover tools available in dataflows, automations and visualizations.

Data processing building blocks

Toric is a visual data experience – from exploration, processing and visualization. Nodes can be connected together to build powerful data-pipelines.
Breakout

Breakout

Extracts a set of columns from the input table.

Clean Up

Clean Up

Trim white spaces, and remove blank rows or non-printable characters in table rows.

Coalesce

Coalesce

Combine one or many columns based on the first non-empty value.

Column Rename

Column Rename

Rename one or more columns in a table, modifying the display names.

Data Tagging

Data Tagging

Create a new column and tag data based on a set of rules.

Diff

Diff

Identify changes in data between two source versions.

Duplicate Column

Duplicate Column

Select and create a copy of any column in your data.

Edit Column

Edit Column

Change the column type or name of one or more columns.

Element At Index

Element At Index

Gives the position (index) of a value in a table.

Element Index

Element Index

Outputs the position (index) of a value in a table.

Filter

Filter

Filters data based on the configuration.

Index Of Element

Index Of Element

Provides the index of a specific value (opposite to ElementAtIndex).

Keep Rows

Keep Rows

Keep rows at the top or bottom of a table.

Promote Headers 

Promote Headers 

Promotes the next row of a table as the new headers and inference types.

Range Selector

Range Selector

Displays all the rows between two rows indexes.

Remove Columns

Remove Columns

Remove rows from the top or bottom of a table.

Remove Rows

Remove Rows

Remove rows from the top or bottom of a table.

Reorder Columns

Reorder Columns

Reorders columns in a table relative to other columns.

Sort

Sort

Sort table records in ascending or descending order based on selected fields.

Text Truncate

Text Truncate

Takes several characters from the left or right side of the text as a new column.

Unnest

Unnest

Translate an array of columns into a set of records.

Append

Append

Append rows from two different sources, sharing columns with the same name and type.

Combine Columns

Combine Columns

Combine columns by merging column values into a single value.

Concatenate

Concatenate

Concatenates two tables as a single table, merging the columns of the two tables.

Data Mapper 

Data Mapper 

Remap data from existing fields into a new data structure.

Find and Replace

Find and Replace

Replaces the value of a cell by searching and matching conditions.

Group By

Group By

Groups table records based on the selected fields.

Join

Join

Combine columns, entire tables, or both by joining them by columns and direction selected.

Pivot

Pivot

Flip and summarize data by transforming columns to rows.

Place As Index

Place As Index

Outputs the row at a specific index in a table.

Pluck Column

Pluck Column

Selects and copies a specific column from a table.

ReGex Extract

ReGex Extract

Find and extract data using regular expression.

ReGex Replace

ReGex Replace

Find and replace data using regular expression.

Repeat

Repeat

Displays appended copies of the input value.

Split

Split

Splits a column into multiple columns using a delimiter value.

Stack

Stack

Stack data from the same source by a selected column.

String Concatenate

String Concatenate

Combines two columns together into a new column.

Summarize

Summarize

Creates a new table of summarized values, preserving groups.

Transpose

Transpose

Flip data along it's diagonal turning columns to rows.

Ungroup

Ungroup

Remove record groups by flattening the table.

Unique

Unique

Extracts the distinct values from input data.

Boolean

Boolean

Generates a true or false value that is constant.

Currency

Currency

Generates a value of currency respecting the localization settings.

Date

Date

Generates a Date value that is constant.

Feet

Feet

Generates a unit of measure in feet. Use this node to create a constant value.

Number

Number

A number that can be changed into a decimal (float), integer, or an unassigned integer.

Random Number

Random Number

Produces a random number that regenerates every time the node is evaluated.‍

Stable Random

Stable Random

Produces a random number that remains the same regardless if the node is re-evaluated.

Text

Text

An editable text field that can be changed.

Time Now

Time Now

A Generate node that shows the Time Now

Unit

Unit

Generates a unit of measurement in high precision.

Absolute

Absolute

Converts any negative number into positive number.

Add

Add

Add two single numbers or two columns of any number type.

Average

Average

Calculates the average of numbers in a column.

Ceiling

Ceiling

Rounds the input number to the highest integer number closest to the input.

Column Names

Column Names

Get a list of column names in your data.

Cosine

Cosine

A function that provides the length of the adjacent side divided by the hypotenuse length.

Count

Count

Calculates the number of rows in a table.

Divide

Divide

Divide two single numbers or two columns of any number type.

Field Calculator

Field Calculator

Adds new columns with results calculated from other columns.

Floor

Floor

Rounds the input number to the lowest integer number closest to the input.

Formula

Formula

Type formulas using data fields to calculate new values.

Group Count

Group Count

Calculates the number of groups in a table.

Max

Max

Returns the maximum value of the selected number column in the input.

Min

Min

Returns the minimum value of the selected number column in the input.

Multiply

Multiply

Multiply two single numbers or two columns of any number type.

Round

Round

Replaces the input number with the nearest integer number.

Sine

Sine

Provides the input number of a ratio between the long side (hypotenuse) and the side that is counter to an acute angle in a right triangle.

Subtract

Subtract

Subtract two single numbers or two columns of any number type.

Sum

Sum

Adds all the values in a column with the total value.

Bigger Than

Bigger Than

Output is true if the value of input A is bigger than the value of input B.

If

If

Evaluates if the condition of an input value is true or false.

Is Equal

Is Equal

Output is true if the value of inputA and inputB are the same.

Less Than

Less Than

Output is true if the value of inputA is less than the value of inputB.

Coming Soon

Get in touch

Request a demo, or free trial.