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 values in the input columns, remove blank rows or non-printable characters.

Clean Up

Trim values in the input columns, remove blank rows or non-printable characters.

Renames columns in a table, modifying the display name.

Column Rename

Renames columns in a table, modifying the display name.

Change the type and/or name of one or more columns.

Edit Column

Change the type and/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 the input data based on the configuration.

Filter

Filters the input 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 as the new headers for the file, inferencing types.

Promote Headers 

Promotes the next row as the new headers for the file, inferencing types.

Displays all the rows between two specific positions.

Range

Displays all the rows between two specific positions.

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.

Uses selected fields to sort table records in ascending or descending order.

Sort

Uses selected fields to sort table records in ascending or descending order.

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.

Append rows together, sharing columns with the same name and type.

Append

Append rows together, sharing columns with the same name and type.

Combine columns together, merging column values into a single value.

Combine Columns

Combine columns together, merging column values into a single value.

Smartly concatenates two tables, forming a single table with the union of the columns from the two tables.

Concatenate

Smartly concatenates two tables, forming a single table with the union of the columns from 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 for all rows that match a search condition.

Find and Replace

Replaces the value of a cell for all rows that match a search condition.

Groups table records together based on the selected fields.

Group By

Groups table records together based on the selected fields.

Combines columns, entire tables, or both by joining them based on the columns and join direction selected.

Join

Combines columns, entire tables, or both by joining them based on the columns and join 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, respecting groups.

Summarize

Creates a new table of summarized values, respecting groups.

Change text casing on a text data column.

Text Transform

Change text casing on a text data column.

Remove groups from an input, flattening the table.

Ungroup

Remove groups from an input, 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.

Generates a unit of measurement in high precision.

Unit

Generates a unit of measurement in high precision.

Turns any negative numbers into positive number.

Absolute

Turns any negative numbers into positive number.

Adds (+) two numbers or two columns of numbers.

Add

Adds (+) two numbers or two columns of numbers.

Calculates the average of numbers on a column.

Average

Calculates the average of numbers on 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.

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.

Divides two single numbers (of any type) or two columns of numbers.

Divide

Divides two single numbers (of any type) or two columns of numbers.

Adds new columns of values that are calculated from other columns.

Field Calculator

Adds new columns of values that are 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.

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.

Multiples two single numbers (of any type) or two columns of numbers.

Multiply

Multiples two single numbers (of any type) or two columns of numbers.

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 singles (of any type) or two columns of numbers.

Subtract

Subtract two singles (of any type) or two columns of numbers.

Adds the total of all input numbers or values or adds all the values in a column.

Sum

Adds the total of all input numbers or values or adds all the values in a column.

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.

Creates a new Data App when triggered within an automation.

Create Viz

Creates a new Data App when triggered within an automation.

Sends an email notification to a list of recipients when triggered.

Send Email Notification

Sends an email notification to a list of recipients when triggered.

Sets off action nodes in the Dataflow when a source is modified.

Source Change Trigger

Sets off action nodes in the Dataflow when a source is modified.

Get started today

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