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 fomula editor provides live syntax checking and preview, complete language reference and examples.