distinct Function | Vantage CX - distinct - Vantage Customer Experience

Vantage Customer Experience User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Vantage Customer Experience
Release Number
1.6
Published
October 2023
Language
English (United States)
Last Update
2023-10-26
dita:mapPath
hbt1563223944614.ditamap
dita:ditavalPath
oyf1565965838286.ditaval
dita:id
tmo1562969305444
Product Category
Teradata Applications

Returns a list of values that are unique within a set.

In the following criteria expression, the distinct function returns the set of unique price attribute values from the complex attribute category named cart. The following expression evaluates as true when the count of unique price attribute values from the cart complex attribute category is greater than 13.

count(
    distinct(
        get("Account.cart"),
         "price"
    )
) > 13

By default, the distinct function accesses the most current data. The Session modifier enables the distinct function to access the session data, which is all of the data in the active session. For example, the Session modifier accesses not only the current value for an attribute but all the previous values for that attribute in the session. Use the Session modifier to use a simple attribute with the distinct function.