Data Transform
Overview
The Data Transform node applies column-level transformations to upstream data rows. It handles field renaming, reordering, type casting, computed column creation, and field removal — all in-memory without database access.
Category
Data — data/dataTransform
Settings
| Setting | Type | Default | Description |
|---|---|---|---|
| transforms | Array | [] | List of transform operations to apply sequentially |
| transform.type | String | — | rename, cast, drop, add, reorder |
| transform.field | String | — | Target field name |
| transform.value | Any | — | New name (rename), type (cast), or expression (add) |
Inputs & Outputs
- input1 — Upstream data array
- output1 — Transformed data with modifications applied
Use Cases
- Normalize CSV imports — Rename
First Name→firstName, castageto number - Prepare dashboard data — Drop internal fields, add computed
fullNamecolumn - API response shaping — Reorder and rename fields before returning via API Response node