Skip to main content
Data Transform is currently in Preview. Functionality may change.

Data Transform

Transform in flight, not in a pipeline. Real-time field transformations applied at the data boundary. No ETL pipelines or data duplication required.

Operations

Combine

Merge two string fields into a single new field.
controls:
  - type: combine
    fields:
      - first_name
      - last_name
    into: full_name
    separator: " "
Input:
{ "first_name": "Jane", "last_name": "Doe", "email": "jane@example.com" }
Output:
{ "first_name": "Jane", "last_name": "Doe", "full_name": "Jane Doe", "email": "jane@example.com" }

Coalesce

Select the first non-empty value from two fields of the same type. Ideal for fallback logic and data normalization.
controls:
  - type: coalesce
    fields:
      - mobile_phone
      - home_phone
    into: primary_phone
Input:
{ "mobile_phone": "", "home_phone": "555-1234" }
Output:
{ "mobile_phone": "", "home_phone": "555-1234", "primary_phone": "555-1234" }

Combining with privacy controls

Apply transformations before or after privacy controls:
controls:
  # First, combine name fields
  - type: combine
    fields: [first_name, last_name]
    into: full_name
    separator: " "

  # Then, anonymize the combined name
  - type: anonymize
    fields:
      - full_name

  # Redact the original fields
  - type: redact
    fields:
      - first_name
      - last_name

Removing original fields

Optionally remove source fields after transformation:
controls:
  - type: combine
    fields: [first_name, last_name]
    into: full_name
    separator: " "
    remove_source: true
Output:
{ "full_name": "Jane Doe", "email": "jane@example.com" }

Next steps