Formula

This processor computes new columns using formulas based on other columns (like in a spreadsheet). The formula language provides:

• Math functions

• String manipulation functions

• Date handling functions

• Boolean and conditional expressions for rules creation

Usage examples

• Compute a numerical expression: (col1 + col2) / 2 * log(col3)

• Manipulate strings : toLowercase(substring(strip(mytext), 0, 7))

• Create a rule-based column: if (width > height, "wide", "tall")

Getting help

The formula editor provides live syntax checking, preview of results, a complete language reference, and examples.