Named Tables & Rules Engine

Create, load, query, and transform persistent and transient data tables; apply business rules

Activity	What it does
Apply Rule Set	Applies a named rule set to a table. Rules are applied in order and may reference lookup tables for commission rates, al
Create Table	Creates a new in-memory (transient) table for data processing within the workflow.
Delete Row from Table	Removes the first row from an in-memory table whose key-column values match the provided keys. Requires key columns to b
Drop Table	Removes an in-memory table and frees its memory.
Export Table to File	Exports an in-memory table to a CSV or Excel file.
Export with Template	Exports a table using a named export template with column mapping and format conversion.
Import File into Table	Reads a CSV or Excel file into a named in-memory table on the runner. Only metadata (tableName, columns, totalRows) is r
Load Named Table	Loads a persistent Named Table from the platform into memory for use in subsequent table activities.
Merge Tables	Merges all rows from a source table into a target table. Supports append or key-based upsert.
Push Row to Table	DEPRECATED: Use TableUpsertRow for single-row writes or TableMerge for bulk merges. Still fully functional. Adds or upse
Query Table	Filters, sorts, and projects columns from a table. Returns a new table with the results.
Save Named Table	Persists an in-memory table back to the platform as a Named Table.
Set Table Key Columns	Updates the key columns of an in-memory table and rebuilds its index.
Table Lookup	Looks up a single row by exact key match. Returns the matched row or null.
Table Match	Wildcard-aware lookup with specificity scoring. Finds the best-matching row, supporting '*' wildcards in table data.
Upsert Row in Table	Adds a row to an in-memory table, or replaces an existing row matched by the table's key columns. Preferred over TablePu