4 Replies Latest reply: Feb 23, 2017 3:03 PM by John-Harald Holmlund RSS

    multiple where statements and where match statement in Load scripts

    Sara Vasquez

      I have the following load

      LOAD

          Subject,

          "Override Flag",

          num(Grade) as Grade,

          "School Performance School Flag",

           "Attributed District Name"

        

      FROM [my file]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

      WHERE MATCH ("Subject",'M', 'R','E' ,'S')

      WHERE ("Attributed District Name"='PHILADELPHIA CITY SD') and ("School Performance School Flag"='Y')

      and ("Grade"<'11')

      ;

       

      I can run it with just the Where Match part or with the multiple Where statement, but how would I be able to mix both. Also how would I be able to change the value of the subject 'M' to 'Math'. Any help is appreciated. I have experience with R, Tableau and some SQL, but a beginner when it comes to Qlik sense load scripts.

       

      Thanks