Hi Community, I have 2 mvfields, how can I search for all the values in the first mvfield to all the values in the second mvfield? index=animals | eval all_animals = mvappend('animal1', 'animal3', 'animal3') | table id_animals all_animals
id_animals
all_animals
001
dog
goat
cow
002
tiger
lion
003
parrot
snake
boar
index=pets | eval all_pets = mvappend('pet1', 'pet2') | table id_pets all_pets
id_pets
all_pets
A1
parrot
mouse
A2
dog
cat
result:
id_animals
animals
id_pets
001
dog
cat
mouse
A2
002
tiger
lion
NO MATCH
003
parrot
snake
A1
... View more