Expression
Overview
The Expression node evaluates mathematical and data expressions with field references. It implements a proper expression parser (no eval()) supporting arithmetic, string functions, date functions, conditionals, and type conversion.
Category
Math — math/expression
Supported Functions
| Category | Functions |
|---|---|
| Math | abs, ceil, floor, round, min, max, sqrt, log, pow |
| String | CONCAT, UPPER, LOWER, LEFT, RIGHT, REPLACE, SUBSTR, LEN, TRIM, LPAD |
| Date | YEAR, MONTH, DAY, DATEDIFF, YEARMONTH, YEARWEEK, DATEFORMAT, NOW |
| Conditional | IF, IFNULL, COALESCE |
| Type | TONUMBER, TOTEXT |
Inputs & Outputs
- input1 — Upstream data (field values available in expressions)
- output1 — Each row with the computed field added