Shapes

Reshape and enrich records

Data table

Reads and writes one of your built-in data tables, with a visual query editor.

Nodes › TransformOpen in Neblex
Good for
Storing data between runs
Role
Works on the records in a flow
Find it in
Nodes › Transform

When to use it

  • You need to keep state between runs, such as reference lists or processed ids.
  • Flows and apps should share a dataset without an external database.
  • You want joins and conditions without writing SQL.

Reach for something else when

Connector stepWhen the data belongs in your own database.

Example

Insert or update each processed order by order_id, so an app can show today's status.

  1. Webhook
  2. Map fields
  3. Data table

How it works

Settings
Data table; Operation: Insert [default], Insert or update, Get, Update, Delete, List all rows, Query rows, Describe columns; Key column (for insert-or-update, get, update, delete); row values mapped in Input.
Query rows
A safe query editor: joins (inner or left), return columns with friendly names, Where all are true conditions (equals, does not equal, >, ≥, <, ≤, contains, starts with, ends with, is empty, is not empty) with fixed values or incoming fields, sort column, Descending, and a row limit. No SQL is needed.
Output
Writes act per record and pass on the result; reads return rows as records.
More in the guide

Add it to a flow

  1. Open the flow from Build › Workflows.
  2. Open Nodes and find Data table under Transform, or search for it. Click it or drag it onto the canvas.
  3. Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
  4. Run the flow and click the step to see the records it received and produced.

More in Reshape and enrich records

Map fields and Transform itemsBuilds a new record field by field in the Transform Studio, with a live preview.Nodes › TransformEdit fieldsApplies a list of set, rename and remove rules to every record in one step.Nodes › TransformSet fieldsAdds or overwrites some fields and removes others; everything else passes through.Nodes › TransformRename fieldsRenames fields, one rename per line.Nodes › TransformLookupAdds a matching record from an earlier step to each record, without a database.Nodes › TransformBuild textRenders a text template with placeholders from the record into a field.Nodes › Transform