In the attached Excel sample, I have 2 rows for each transaction based on EMPID. I only want to load the 2 rows if the "Matched" column has equal values for the 2 rows. So in my example, I don't want the first 2 or last 2 rows to load because the values are "I" and "O" for EMPID 1, and "A" and "B" for EMPID 4. Is there a way to do this on a load statement, and if not, how can it be done in the dashboard? I don't want to see those rows at all in the dashboard if the "Matched" values are not equal. I've tried different things with a Where clause, but I can't figure out how to compare the rows to find out if they match or not.
