I would like to creat ea flag for when these two conditions are met:
IF(Count(Distinct(First_Key) <> Count(Distinct(Second_Key), 1, 0)))
but I don't quite get the syntax. Does this need to be a set analysis?
I just want to rerutn a 1 if the number of unque first_key is not the same as the number of unique second_key.