Steps

Each step works on the rows of the step before it; Join, Concatenate and Compare work on two. Add one from the palette, or from Add Items, after the selected step. Click a step on the graph to edit it: every editor has the parts shown on The editor, and Apply stores the changes as one step to undo.

Rows

• Filter by Column: Keeps the rows that match conditions on their columns.
• Filter by Expression: Keeps the rows for which a Pure expression is true, for conditions Filter by Column can't express, such as arithmetic across columns.
• Distinct Values: Keeps one row of each set of identical rows.
• Drop first rows: Leaves out the first rows.
• Take first rows: Keeps the first rows.
• Take a range of rows: Keeps the rows from a start row up to, but not including, a stop row, counting from 0.

Columns

• Restrict Columns: Keeps only the columns ticked.
• Rename Columns: Gives columns new names.
• Extend Columns: Adds columns computed from each row by Pure expressions.

Order

• Sort by Column: Reorders the rows by one or more columns, each ascending or descending.

Aggregations

• Group by Column: Makes one row for each combination of the group columns' values, with aggregations of the rows in it.
• Pivot by Column: Turns the values of one column into columns.
• Apply Window Functions: Adds columns computed over windows of rows, such as a rank or a running total, keeping every row.

Two inputs

• Join Another Input: Joins two inputs on pairs of columns.
• Concatenate Another Input: Gives the rows of two inputs, keeping duplicates, in no particular order.
• Compare Column Values: Matches the rows of two inputs on join columns and, for each difference column, gives both values and their difference.

JSON

• Explode Array: Makes a row for each element of an array in a JSON (Variant) column, keeping the other columns and adding the element as a new column.