DataOps building blocks

Get data analytics-ready faster with no coding Nodes and streamline activities using Automations.
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.

Write to Warehouse

Write to Warehouse

Map and write data to an internal or external warehouse.