Data Transformation

Revo provides a visual editor for field mapping, filtering, aggregation, strings, dates, and math, plus a JavaScript JSON editor for transformations the visual library does not cover.

How it works

Every value from earlier steps is available as an input, including single fields, full records, arrays, and nested objects. You browse the variables panel, select a value, and it lands in a transform node. You then choose a transformation from the visual library, configure it by picking a field, an operator, and a value, and watch a live preview update before saving. The transformed value becomes a new variable available to every later step.

For edge cases such as a complex dedup rule or a custom format parser, the JavaScript editor opens with full language access, syntax highlighting, autocomplete, and live preview. The visual editor covers most business transformations and the JavaScript editor is the escape hatch.

Key capabilities

• Field mapping between steps, including renaming keys and restructuring objects.
• Visual filtering on any field with equality, ranges, contains, starts and ends with, regex, and is empty, combined with AND or OR.
• Aggregation functions: sum, count, average, min, and max, with an optional group by field.
• String operations: concatenate, split, replace, trim, change case, extract substrings, match patterns, and template formatting.
• Date arithmetic and formatting with correct timezone handling by default.
• JavaScript JSON transforms for edge cases not covered by the visual editor.
• Live validation that flags missing fields, mismatched types, and invalid references inline.

Tips