Prepare

Extracts a set of columns from the input table.

Prepare

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

Prepare

Renames columns in a table, modifying the display name.

Prepare

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

Prepare

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

Prepare

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

Prepare

Filters the input data based on the configuration.

Prepare

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

Prepare

Keep rows at the top or bottom of a table.

Prepare

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

Prepare

Displays all the rows between two specific positions.

Prepare

Remove rows from the top or bottom of a table.

Prepare

Remove rows from the top or bottom of a table.

Prepare

Reorders columns in a table relative to other columns.

Prepare

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

Prepare

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

Transform

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

Transform

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

Transform

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

Transform

Remap data from existing fields into a new data structure.

Transform

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

Transform

Groups table records together based on the selected fields.

Transform

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

Transform

Outputs the row at a specific index in a table.

Transform

Selects and copies a specific column from a table.

Transform

Displays appended copies of the input value.

Transform

Splits a column into multiple columns using a delimiter value.

Transform

Combines two columns together into a new column.

Transform

Creates a new table of summarized values, respecting groups.

Transform

Change text casing on a text data column.

Transform

Remove groups from an input, flattening the table.

Transform

Extracts the distinct values from input data.

Generate

Generates a true or false value that is constant.

Generate

Generates a value of currency respecting the localization settings.

Generate

Generates a Date value that is constant.

Generate

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

Generate

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

Generate

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

Generate

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

Generate

An editable text field that can be changed.

Generate

Generates a unit of measurement in high precision.

Calculate

Turns any negative numbers into positive number.

Calculate

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

Calculate

Calculates the average of numbers on a column.

Calculate

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

Calculate

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

Calculate

Calculates the number of rows in a table.

Calculate

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

Calculate

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

Calculate

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

Calculate

Calculates the number of groups in a table.

Calculate

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

Calculate

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

Calculate

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

Calculate

Replaces the input number with the nearest integer number.

Calculate

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.

Calculate

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

Calculate

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

Control Flow

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

Control Flow

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

Control Flow

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

Control Flow

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

Automation

Creates a new Data App when triggered within an automation.

Automation

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

Automation

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