@samiksha86, based on the sample data provided try the following run anywhere search. Command from makeresults
till | table test host1 host2 host3
generates the sample data as per the question.
| makeresults
| eval data="test1 x1 x1 x1;test2 y1 y2 y1;test3 z1 z2 z3"
| makemv data delim=";"
| mvexpand data
| makemv data delim=" "
| eval test=mvindex(data,0),host1=mvindex(data,1),host2=mvindex(data,2),host3=mvindex(data,3)
| table test host1 host2 host3
| eval temp=host1.",".host2.",".host3
| makemv temp delim=","
| eval temp=mvdedup(temp), matchCount=mvcount(temp), temp=if(matchCount=1,"Matched","Not Matched")
@niketnilay, what if the the values i.e. x1,x2y1,z1,etc are subject to changes and we have to compare then.
How to compare in that scenario?