Create fag when two conditions are met

[Anonymous]

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.

[jonathandienst · Accepted solution]

Hi

You have some misplaced parentheses. This should work:

IF(Count(Distinct First_Key) <> Count(Distinct Second_Key), 1, 0)

Regards

Jonathan