2 Replies Latest reply: Jun 7, 2015 5:55 AM by Josephine Feldhoff RSS

    Logical and or with match

      I hava a problem with the following code:

       

      Load

      name,

      1 as _Flag

      Where

        ( Match(COURSE ,'ENG2', 'ENG3') or Match(GRADE,'E', 'D','C', 'B','A' ))

        And (Match(COURSE,  'MATH5') or Match(GRADE, 'E', 'D','C', 'B','A' ))

       

      Meaning that if a person attended both of the courses in English and got a valid grade and also attended the 'MATH5' class and got a valid grade in that course too then the Flag=1

       

      I get to many records when I run the code above and not sure what I'm thinking wrong.