Really nice solution @tiago. 6 years later I could additionally mention that you can now use the foreach command to loop through the mv-fields to avoid the mvexpand. Here is my example in case you want to compare the mv-fields bi-directional: | makeresults
| eval F1=split("a,b,c,z",","),F2=split("a,b,c,d",",")
| foreach mode=multivalue F1
[ eval only_in_F1 = mvsort(if(isnull(mvfind(F2,<<ITEM>>)),mvappend(<<ITEM>>,only_in_F1),only_in_F1))
]
| foreach mode=multivalue F2
[ eval only_in_F2 = mvsort(if(isnull(mvfind(F1,<<ITEM>>)),mvappend(<<ITEM>>,only_in_F2),only_in_F2))
]
... View more