Error: An expression cannot end with an operator

[SACResearch]

Hi!

I am trying to filter by two variables, but I am getting an error that states that an expression can not end with an operator. Can you someone tell me what I'm doing wrong?

[right_subj_no]= “MATH” and [right_course_no]= “83” or

[right_subj_no]= “CNSL” and [right_course_no]= “107” or

[right_subj_no]= “MATH” and [right_course_no]= “219” or

[right_subj_no]= “ENGL” and [right_course_no]= “101” or

[right_subj_no]= “ENGL” and [right_course_no]= “N60” or

[right_subj_no]= “MATH” and [right_course_no]= “84” or

[right_subj_no]= “ENGL” and [right_course_no]= “61” or

[right_subj_no]= “MATH” and [right_course_no]= “160” or

[right_subj_no]= “BIOL” and [right_course_no]= “109” or

[right_subj_no]= “CJ” and [right_course_no]= “101” or

[right_subj_no]= “CNSL” and [right_course_no]= “116” or

[right_subj_no]= “MATH” and [right_course_no]= “N48” or

[right_subj_no]= “SOC” and [right_course_no]= “100” or

[right_subj_no]= “MATH” and [right_course_no]= “140” or

[right_subj_no]= “PSYC” and [right_course_no]= “100” or

[right_subj_no]= “ENGR” and [right_course_no]= “100A” or

[right_subj_no]= “HIST” and [right_course_no]= “120” or

[right_subj_no]= “HUD” and [right_course_no]= “107” or

[right_subj_no]= “JAPN” and [right_course_no]= “101” or

[right_subj_no]= “MATH” and [right_course_no]= “150” or

[right_subj_no]= “CMPR” and [right_course_no]= “120” or

[right_subj_no]= “ECON” and [right_course_no]= “120” or

[right_subj_no]= “CHST” and [right_course_no]= “101” or

[right_subj_no]= “MATH” and [right_course_no]= “219H” or

[right_subj_no]= “MUS” and [right_course_no]= “103” or

[right_subj_no]= “PHIL” and [right_course_no]= “106” or

[right_subj_no]= “READ” and [right_course_no]= “101” or

[right_subj_no]= “ANTH” and [right_course_no]= “101” or

[right_subj_no]= “ART” and [right_course_no]= “100” or

[right_subj_no]= “ASTR” and [right_course_no]= “110” or

[right_subj_no]= “BUS” and [right_course_no]= “150” or

[right_subj_no]= “CHEM” and [right_course_no]= “209” or

[right_subj_no]= “CJ” and [right_course_no]= “205” or

[right_subj_no]= “CMST” and [right_course_no]= “101” or

[right_subj_no]= “CMST” and [right_course_no]= “102” or

[right_subj_no]= “CNSL” and [right_course_no]= “100” or

[right_subj_no]= “DNCE” and [right_course_no]= “102” or

[right_subj_no]= “EDUC” and [right_course_no]= “100” or

[right_subj_no]= “HIST” and [right_course_no]= “121” or

[right_subj_no]= “IDS” and [right_course_no]= “155” or

[right_subj_no]= “KNFI” and [right_course_no]= “112A” or

[right_subj_no]= “LIBI” and [right_course_no]= “100” or

[right_subj_no]= “MATH” and [right_course_no]= “80” or

[right_subj_no]= “MATH” and [right_course_no]= “105” or

[right_subj_no]= “STDY” and [right_course_no]= “109” or

[right_subj_no]= “ACCT” and [right_course_no]= “101” or

[right_subj_no]= “ANTH” and [right_course_no]= “100” or

[right_subj_no]= “ANTH” and [right_course_no]= “100H” or

[right_subj_no]= “ART” and [right_course_no]= “110” or

[right_subj_no]= “ART” and [right_course_no]= “130” or

[right_subj_no]= “ART” and [right_course_no]= “195” or

[right_subj_no]= “AUTO” and [right_course_no]= “2” or

[right_subj_no]= “AUTO” and [right_course_no]= “6” or

[right_subj_no]= “AUTO” and [right_course_no]= “22” or

[right_subj_no]= “AUTO” and [right_course_no]= “76” or

[right_subj_no]= “BIOL” and [right_course_no]= “109L” or

[right_subj_no]= “BIOL” and [right_course_no]= “149” or

[right_subj_no]= “CJ” and [right_course_no]= “103” or

[right_subj_no]= “CMPR” and [right_course_no]= “100” or

[right_subj_no]= “CMPR” and [right_course_no]= “105” or

[right_subj_no]= “CMST” and [right_course_no]= “140” or

[right_subj_no]= “ECON” and [right_course_no]= “121” or

[right_subj_no]= “ENGL” and [right_course_no]= “101H” or

[right_subj_no]= “ENVR” and [right_course_no]= “140” or

[right_subj_no]= “ERTH” and [right_course_no]= “110” or

[right_subj_no]= “ETHN” and [right_course_no]= “101H” or

[right_subj_no]= “FREN” and [right_course_no]= “101” or

[right_subj_no]= “GEOL” and [right_course_no]= “101” or

[right_subj_no]= “HIST” and [right_course_no]= “101” or

[right_subj_no]= “HIST” and [right_course_no]= “124” or

[right_subj_no]= “KNAD” and [right_course_no]= “211A” or

[right_subj_no]= “KNAF” and [right_course_no]= “140” or

[right_subj_no]= “KNIA” and [right_course_no]= “210” or

[right_subj_no]= “MATH” and [right_course_no]= “70” or

[right_subj_no]= “MATH” and [right_course_no]= “N06” or

[right_subj_no]= “MGMT” and [right_course_no]= “120” or

[right_subj_no]= “MUS” and [right_course_no]= “101” or

[right_subj_no]= “MUS” and [right_course_no]= “104” or

[right_subj_no]= “MUS” and [right_course_no]= “161” or

[right_subj_no]= “PHAR” and [right_course_no]= “48” or

[right_subj_no]= “PHIL” and [right_course_no]= “110” or

[right_subj_no]= “PHOT” and [right_course_no]= “180” or

[right_subj_no]= “POLT” and [right_course_no]= “101” or

[right_subj_no]= “PSYC” and [right_course_no]= “170” or

[right_subj_no]= “READ” and [right_course_no]= “102” or

[right_subj_no]= “READ” and [right_course_no]= “150” or

[right_subj_no]= “READ” and [right_course_no]= “N50” or

[right_subj_no]= “SIGN” and [right_course_no]= “110” or

[right_subj_no]= “SPAN” and [right_course_no]= “101” or

[right_subj_no]= “TELV” and [right_course_no]= “104” or

[right_subj_no]= “THEA” and [right_course_no]= “100” or

[right_subj_no]= “WELD” and [right_course_no]= “8” or

[right_subj_no]= “WMNS” and [right_course_no]= “101”

[JohnJPS]

Could you try putting each "and" into parentheses?   e.g.

([right_subj_no]= “MATH” and [right_course_no]= “83”) or
([right_subj_no]= “CNSL” and [right_course_no]= “107”) or
... etc...

No guarantees it'll help, but who knows...

[RodL · Accepted solution]

Looks like the "quotes" that you are using are not recognized by the expression builder. Are you possibly copy/pasting from something like Word where they are being altered from a standard quote?

If I just take your first line of code and replace with the quotes from within Alteryx, the error disappears.