1 Reply Latest reply: Mar 21, 2012 4:32 PM by Jonathan Dienst RSS

    Create fag when two conditions are met

    Jonathan Love

      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.