Skip to content
Back to

Function

Custom JavaScript transformation function that returns an updated row with optional lineage and audit metadata.

Parameters

  • function (Function Code, string, required) — JavaScript function code. See JSON Configuration for signature and examples. Default: "".

Field selection

  • source — Field whose values this operation reads. Use a single field name, a comma-separated list of plain field paths (cash_flow_type, currency) from the multi-select UI, or a regex via Pattern mode. Omit to apply to all fields on the row.
  • target — Optional output field. When omitted, the source field is updated in place. Hidden when more than one named source field is selected.

JSON Configuration

{
  "id": "op-function",
  "type": "transformation",
  "action": "function",
  "params": {
    "function": "({ row }) => ({\n  row: {\n    ...row,\n    total: row.price * row.quantity,\n  },\n  lineage: [\n    {\n      outputField: \"total\",\n      inputFields: [\"price\", \"quantity\"],\n      usage: \"transformation\",\n    },\n  ],\n})"
  },
  "testInputs": [
    "Hello World",
    "MixedCase",
    "sample text",
    "already",
    "123",
    ""
  ]
}