Where clause not working as expectation

[ankuragrawal]

LOAD
Sno,
"Date",
"Time",
"State/UnionTerritory" as State,
ConfirmedIndianNational,
ConfirmedForeignNational,
Cured,
Deaths,
Confirmed
FROM [lib://DataFiles/covid_19_india.csv]
(txt, utf8, embedded labels, delimiter is ',', msq)
where "State/UnionTerritory" <>'Cases being reassigned to states' or 'Unassigned';

this code is only filtering Cases to be reassigned not unassigned

Please help

[GaryGiles]

Since you are using <>, I think you want to use AND and specify "State/UnionTerritory" twice, like this:

where "State/UnionTerritory" <>'Cases being reassigned to states'  and

"State/UnionTerritory" <> 'Unassigned';

[ankuragrawal]

Its working perfectly fine now,Can you also help me to know, how to remove null values from same column

[GaryGiles · Accepted solution]

where "State/UnionTerritory" <>'Cases being reassigned to states'  and

"State/UnionTerritory" <> 'Unassigned' and

Not isnulll("State/UnionTerritory");

[ankuragrawal]

still null values are appearing at the data model, is null and space same?