Hi edoardo_vicendone,
try something like this:
| makeresults
| eval A="test;sample;example",
B="test;sample;example;check"
| makemv delim=";" A
| makemv delim=";" B
| mvexpand A
| mvexpand B
| stats values(A) AS A by B `comment(" Everything up til here creates events, please ignore ...")`
| eval C=if(B!=A, B, null())
The first 8 lines create, prepare the dummy events and the last line does the actual comparison of field A and B and puts the result into the new field C .
The important part of the SPL is line 4-7 where I create the multi value fields and split them so we are able to compare the values.
Hope this helps ...
cheers, MuS
... View more