Experian Data Quality Community
-
Map path: Targeted transformation in JSON documents
If you’re working with structured JSON data, Map path is your go-to Higher Order Function for applying transformations to specific fields. What it does: MapPath uses a JSONPath expression to locate fields in a JSON document and applies a function to each matched item. Where it works: JSON list JSON record Business Use…
-
Filter list: Keep only what matters
What it does: Returns a new list containing only the items that meet the condition defined by the operator function. Where it works: Comma-separated list JSON list Business Use Cases & Examples: Comma-separated list: Filtering emails with valid format from a list JSON List: Extract customers that matches a certain interest…
-
Any match: Find just one match in a list
What it does: Checks whether at least one item in a list satisfies a condition defined by a Boolean-returning function. Where it works: Comma-separated list JSON list Business Use Cases & Examples: Comma-separated list Flag if any items in the list are a UK postcode: JSON list Identify if the shopping cart contains a…
-
All match: Validate every item in a list
In this post, we will take a closer look at All match, one of the higher order functions now available in Aperture Data studio v3.2. What it does: All match checks whether every item in a list satisfies a condition defined by a Boolean-returning function. Where it works: Comma-separated lists JSON lists Business Use Cases…
-
Unlock powerful list and record logic with the higher order functions (part of List transformation)
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…
