Compare the values of different rows for particular dimension and show the status
So in this image you can see there are two practitioner_id. And the both Practitioner_id are having common Manufacturer and Drug name and the third column is showing matched with which practitioner. So here we can see the third column is published with Matched and 56834216, the practitioner id with which it is matching.
So in third column i want show that both the practitioner's are having matching Manufacturer and drug name.
Re: Compare the values of different rows for particular dimension and show the status
You cannot have a Result field like this because you may have n number of Manufacturer and Drug name repeat for multiple practioners. Which is why i suggested to only keep the Key column which you can select on