This content has been marked as final. Show 4 replies
I have the following load
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')
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.