Knobs icon

Knobs

Visual knob controls for data transformation

Transform Data

AI-generated

Summary

Transform input data by applying configurable operations to strings, numbers, arrays, and dates within objects, producing a transformed JSON output.

Inputs

  • stringOperations — Configure minimum string length to process, case sensitivity, and whether to trim whitespace from strings.
  • numberOperations — Set number rounding precision, minimum and maximum allowed values, and scale factor multiplier for numeric values.
  • arrayOperations — Define maximum number of items to process in arrays, whether to skip empty arrays, and chunk size for splitting large arrays.
  • dateOperations — Specify date format, timezone offset in hours from UTC, and whether to include time in the formatted date output.
  • filterOperations — Control inclusion of null/undefined values, empty strings, and zero values in the output data.

Output shape

a list of JSON objects mirroring the input data but transformed according to the specified operations

The output contains one item per input item. Each item's JSON is transformed recursively: strings, numbers, arrays, and date objects are processed according to their respective operation settings. Items filtered out by settings (e.g., strings below minimum length, excluded values) are removed from the output structure. If 'includeNullValues', 'includeEmptyStrings', or 'includeZeroValues' are false, those values are omitted. Errors can be captured per-item if 'Continue On Fail' is enabled.

Examples

Example 1: Applying a string trim with whitespace removal and number scaling with rounding.

stringOperations with Trim Whitespace enabled, numberOperations with Scale Factor 2 and Number Precision 1 set.

Discussion