Splunk Search

How does dedup treat multivalue fields?

landen99
Motivator

Which events are removed when multivalue comes into play?

0 Karma

landen99
Motivator

The answer on which values in a multivalue field are deduped is this: The multivalue field must match all values in order for it to be deduped:

| stats count | eval field=mvappend("a","b") | append [| stats count | eval field=mvappend("1","2")] | append [| stats count | eval field=mvappend("2","1")] | append [| stats count | eval field=mvappend("a1","b2")] | append [| stats count | eval field=mvappend("a1","b2")] | append [| stats count | eval field=mvappend("a1","a2")] | dedup field

Even the order of the values in the multivalue field matters! Who would've thought?

0 Karma