Exact Match with List functions

Sueann See
Sueann See Experian Super Contributor
edited December 2023 in Tips and tricks

There are a number of List functions that may be useful when you are trying to de-duplicate a list of values within a single column.

Let's take a look at this dataset. How can we de-duplicate the list of fruits for each day?

image.png

Connecting the dataset to a Transform step with List Frequency and List De-duplicate Functions will provide a count of each fruit per day along with the list of unique fruits per day. Records with frequency > 1 indicate that they are duplicates.

image.png
image.png
image.png
image.png

List Frequency provides the count for each value within the Fruits column.

List Deduplicate provides the deduplicated list of Fruits.

Tagged:

Categories