Hey Team,
Let just say I have two different indexes named index1 and index2,
they both have a column/ field in them named C1 and C2, what I basically want to do is I want to match where C1 and C2 are the same and create a new index out of it named as matched and if C1 and C2 are not same then-new index named as mismatched.
One more thing I wanna add before the matching process, I also want to remove duplicate enteries with the same C1 and C2 fields to thier respective to thier index.
Kindly suggest some solution for the same.
Regards,
Sagar Mandal