Unlock powerful list and record logic with the higher order functions (part of List transformation)

Ivan Ng
Ivan Ng Administrator
edited December 19 in Tips and tricks

In this series, we will explore the new set of Higher Order Functions (introduced in Aperture Data Studio v3.2) that bring more flexibility and control to how you work with lists and records in Aperture Data Studio.

These functions allow you to pass another function as a parameter, making it possible to filter, match, and transform data dynamically. Whether you're working with comma-separated lists or complex JSON documents, higher order functions help you apply logic to each item with precision.

Business Impact

These functions are especially useful for:

  • Validating customer data
  • Filtering product catalogs
  • Standardizing formats across datasets
  • Applying business rules or data transformation to JSON-based documents

Here’s what’s included:

  • All match – Check if every item in a list meets a condition
  • Any match – Check if any item in a list meets a condition
  • Filter list – Keep only items that match a condition
  • Map list – Transform each item in a list
  • Map path – Apply transformations to specific parts of a JSON document using JSONPath
  • Map record – Apply logic to each key/value pair in a JSON object (write up coming soon)

Stay tuned as we dive deeper into each function in upcoming posts. First up: AllMatch.