Data processing building blocks
Extracts a set of columns from the input table.
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.
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.
Identify changes in data between two source versions.
Select and create a copy of any column in your data.
Change the column type or name of one or more columns.
Element At Index
Gives the position (index) of a value in a table.
Outputs the position (index) of a value in a table.
Filters data based on the configuration.
Index Of Element
Provides the index of a specific value (opposite to ElementAtIndex).
Keep rows at the top or bottom of a table.
Promotes the next row of a table as the new headers and inference types.
Displays all the rows between two rows indexes.
Remove rows from the top or bottom of a table.
Remove rows from the top or bottom of a table.
Reorders columns in a table relative to other columns.
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.
Translate an array of columns into a set of records.
Append rows from two different sources, sharing columns with the same name and type.
Combine columns by merging column values into a single value.
Concatenates two tables as a single table, merging the columns of the two tables.
Remap data from existing fields into a new data structure.
Find and Replace
Replaces the value of a cell by searching and matching conditions.
Groups table records based on the selected fields.
Combine columns, entire tables, or both by joining them by columns and direction selected.
Flip and summarize data by transforming columns to rows.
Place As Index
Outputs the row at a specific index in a table.
Selects and copies a specific column from a table.
Find and extract data using regular expression.
Find and replace data using regular expression.
Displays appended copies of the input value.
Splits a column into multiple columns using a delimiter value.
Stack data from the same source by a selected column.
Combines two columns together into a new column.
Creates a new table of summarized values, preserving groups.
Flip data along it's diagonal turning columns to rows.
Remove record groups by flattening the table.
Extracts the distinct values from input data.
Generates a true or false value that is constant.
Generates a value of currency respecting the localization settings.
Generates a Date value that is constant.
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.
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.
An editable text field that can be changed.
A Generate node that shows the Time Now
Generates a unit of measurement in high precision.
Converts any negative number into positive number.
Add two single numbers or two columns of any number type.
Calculates the average of numbers in a column.
Rounds the input number to the highest integer number closest to the input.
Get a list of column names in your data.
A function that provides the length of the adjacent side divided by the hypotenuse length.
Calculates the number of rows in a table.
Divide two single numbers or two columns of any number type.
Adds new columns with results calculated from other columns.
Rounds the input number to the lowest integer number closest to the input.
Type formulas using data fields to calculate new values.
Calculates the number of groups in a table.
Returns the maximum value of the selected number column in the input.
Returns the minimum value of the selected number column in the input.
Multiply two single numbers or two columns of any number type.
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.
Subtract two single numbers or two columns of any number type.
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.
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.
Output is true if the value of inputA is less than the value of inputB.
Write to Warehouse
Map and write data to an internal or external warehouse.