I have to create a flag in a dataset where
(IF columns A.a and B.a = A.b and B.b ) then I have to check cols A.c = B.c or A.d = B.d
My Data is like
Can someone help me in case statement. The one I have is not showing correct results. First two columns have to match to figure out discrepancies in next cols. If cols match it is 1 and if c and d cols are not matching then its 0.