Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
You have some misplaced parentheses. This should work:
IF(Count(Distinct First_Key) <> Count(Distinct Second_Key), 1, 0)
Regards
Jonathan
Hi
You have some misplaced parentheses. This should work:
IF(Count(Distinct First_Key) <> Count(Distinct Second_Key), 1, 0)
Regards
Jonathan