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?
