Downloaden

Node-documentatie

Elke Altera-node heeft een eigen referentiepagina: wat hij doet, hoe je hem configureert en wat erin gaat en eruit komt.

In/Out3 nodes

Input DataLoad a local Excel or CSV file from disk and turn it into the first table in your workflow.
ExportWrite one or more tables out to a real Excel or CSV file on disk — the end of the line for a workflow.
BrowseOpen a live, read-only preview of any table in your workflow without altering the data.

Conversion2 nodes

PDF ConverterAnnotate any PDF on an interactive canvas and extract clean, structured data — without touching a line of code.
Page FilterUse a page-number column to tell PDF Converter which pages to actually convert.

Preparation13 nodes

Column EditReorder, rename, and delete columns through a drag-and-drop list — no formulas, no code.
Change TypeConvert a column's values to a clean Number, Text, or Date form, with a fallback for values that won't convert.
Shift ColumnsShift the row values of selected columns up or down by any number of steps — several columns at once, each with its own settings.
Header PromoterWhen your real column headers are sitting in a data row, one click moves them to where they belong.
Index ColumnAdd a simple row-index column numbered 1 to N — no configuration needed.
FilterCompose multi-condition row filters through a visual logic builder — no formulas, no syntax errors.
UniqueRemove duplicate rows based on a set of key columns you choose, keeping the first, last, or none of each group.
Cascade FillFill up or down to propagate a column's last-seen value into the empty cells around it.
CleanerBuild an ordered list of text-cleaning operations — trim, case, strip, replace — and apply them to any columns.
FormulaAdd a new column computed from a formula referencing other columns — like Power Query's Add Custom Column.
Add ColumnAdd a new column based on an ordered list of conditions — like Power Query's Add Conditional Column.
BridgePasses its input straight through unchanged — a tidy junction point for organizing a busy workflow.
SortSort rows by one or more columns, ascending or descending — like Excel's Sort dialog.

Transform3 nodes

Unpivot ColumnsTurn selected columns into Attribute/Value row pairs — like Power Query's Unpivot Columns.
Pivot ColumnsTurn a labels column into new column headers and a values column into their contents — like Power Query's Pivot Column.
Group ByGroup rows by one column, then calculate metrics for every group — one output row per group.

Join3 nodes

Horizontal StackCombine two or more tables side by side, matching rows purely by position.
MergeCombine two tables by matching rows on shared columns or row position, with a choice of join type.
ConcatenateStack two or more tables' rows into one, matching columns by name.

Parse2 nodes

Regular ExpressionsExtract regex matches from a column into new columns, with a live match preview and three extraction modes.
Text ParserNo-code text extraction and splitting — before/after/between delimiters, character ranges, and delimiter splits.

Analysis2 nodes

SummaryPer-column stats, distributions, and missing-value/gap detection — a quick health check of a table.
AggregateCollapse an entire table into a single row of sums, averages, counts, minimums, and maximums.
Video-tutorials bekijkenAfspeellijst op YouTube bekijken