isSubset

Description

Returns true if array1 is a subset of array2, or false otherwise.

• When comparing array1 and array2, duplicates are discarded. This means two arrays of different lengths but with the same unique elements are considered equal.
• Supported element types include string, bool, number, interval, timestamp, regexp, and enum.

Syntax

Like many functions in DataPrime, isSubset supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.

isSubset(array1: array<T>, array2: array<T>): bool

(array1: array<T>).isSubset(array2: array<T>): bool

Arguments

Example

Use case: Verify if started jobs are part of all jobs

Suppose you want to confirm that a list of started jobs is fully contained within the list of all jobs. Consider the following input:

{
    "all_jobs": ["Chris", "Quinn", "Flo", "Meta", "Neo"],
    "started_jobs": ["Chris", "Quinn"]
}

By applying isSubset, you can check if every element of started_jobs exists within all_jobs.

Example query

create is_subset from isSubset(started_jobs, all_jobs)

create is_subset from started_jobs.isSubset(all_jobs)

Example output

The result will include a new field is_subset indicating whether the subset condition is satisfied:

{
    "all_jobs": ["Chris", "Quinn", "Flo", "Meta", "Neo"],
    "started_jobs": ["Chris", "Quinn"],
    "is_subset": true
}