Splunk Search

How does dedup treat multivalue fields?

Motivator

Which events are removed when multivalue comes into play?

0 Karma

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
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes
and swag!