Arithmetic Conversion Rule (conversion
) β
Performs arithmetic operations on column values using operators (+, -, *, /).
Field | Description | Required |
---|---|---|
operator | The arithmetic operator: "+", "-", "*", or "/" | β Yes |
value | The numeric value to use in the operation | β
Yes (if column not specified) |
column | Alternative 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.