multiple where statements and where match statement in Load scripts

[#1]

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

[Anonymous · Accepted solution]

You can only have one WHERE, maybe try something like this

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

and ("Attributed District Name"='PHILADELPHIA CITY SD')

and ("School Performance School Flag"='Y')

and ("Grade"<'11')

[#3]

Thanks, that works. Any idea on my second questions?

[Anonymous]

Best to just have one question per thread.  Also not sure I understand your other question so maybe open another thread clarifying your question M question.

[holmlund]

If(Subject='M', 'Math', Subject) as Subject