mvdedup()

Table of Contents

Definition

mvdedup() takes a multivalue column as an argument and returns that multivalue column with the duplicate values removed.

Examples

The following example removes duplicated values in the multivalue column 'pets'.

| makeresults
| eval participants=mvappend("Carol", "Carlos", "Carol")
| eval dedup=mvdedup(participants)
Screenshot of the previous example’s result

Further Reading