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 tables, sharing columns with the same name and type.

Append

Append rows from two different tables, 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.

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.

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.

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.

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.