Deduplicate Values in Array

Remove duplicate values in an array using array:dedup()

logscale

parseJson()
| array:dedup("emails[]")

The array:dedup() function can be used to remove duplicate values in an array.

In this example, the function removes duplicates in the array emails[].

Example incoming data might look like this:

Raw Events

{"emails": ["john@mail.com", "admin@mail.com", "jane@mail.com", "admin@mail.com"]}

Starting with the source repository events.
logscale
```
parseJson()
```
Parses the incoming data to identify JSON values and converts them into a usable field.
logscale
```
| array:dedup("emails[]")
```
Removes duplicate values in the array emails[].
Event Result set.

The query is used to remove duplicate values in an array.

Sample output from the incoming example data:

emails[0]	emails[1]	emails[2]
john@mail.com	admin@mail.com	jane@mail.com