Icon

BONUS - Column Expressions

Column Expressions Node

Allows the user to use Javascript syntax to transform, calculate, or create new columns in table data. It processes row-by-row, allowing complex or multi-condition operations, combining string, numeric, or conditional transformations in a single step over many columns at once.

Delete text in column if contains the text "/ U"
Nicely format a number as a string currency
  • Convert the 'double' column (numerical type) into a string

  • Delimit with commas

  • Add a $ sign

Extract relevant product code based on rules

Need to extract product codes from transactions with the following conditions:

  • If the onsite transaction starts with “L”, then take its first 12 digits, otherwise take its first 6 digits

  • If the 'Onsite' column has a missing value, then take the string from the Online column.

Use Regex expression to extract dates from a text field
Table Creator
Column Expressions
500000000 30000000 200000000
Table Creator
$500,000,000 $30,000,000 $200,000,000
Column Expressions
Table Creator
Modified Transactions
Column Expressions
Personal notes
Table Creator
Extract with regex
Column Expressions

Nodes

Extensions

Links