Skip to content

Arithmetic Conversion Rule (conversion) ​

Performs arithmetic operations on column values using operators (+, -, *, /).

FieldDescriptionRequired
operatorThe arithmetic operator: "+", "-", "*", or "/"βœ… Yes
valueThe numeric value to use in the operationβœ… Yes (if column not specified)
columnAlternative column to use as the second operandβœ… Yes (if value not specified)

Example: ​

json
{
    "type": "conversion",
    "source_column": "hours",
    "destination_column": "minutes",
    "operator": "*",
    "value": 60
}

Behavior: Multiplies values in the hours column by 60 and stores the result in the minutes column.