Hello Splunkers,
I am trying to compare two multi value ID columns, and return true when at least of the values matches between these 2 ID columns.
For example:
ID1
ID2
Match
402830 602369
602369 244633
TRUE
402830 840317 602369
602369 244633
TRUE
152893 443482
602369 244633
FALSE
227213 244633
602369 244633
TRUE
422210 442824
602369 244633
FALSE
The question is how to create the Match column by comparing ID1 to ID2. They are both multi value fields, and one field could contain up to 25 values. As long as there is one match between ID1 and ID2, the match returns TRUE.
I have tried match() and mvfind(), but haven't found any luck.
Thanks all!
... View more