Discussion Board for collaboration on QlikView Scripting.
How do I drop a row if a field value is a certain value in that row?
Go to Solution.
if you like to do it during reload, you may exclude those rows using "where" clause
there isn't a (like sql)
delete .... from ... where ....
if you don't want a row you exclude it during the load (as Dariusz said)
//or if you have a table t
load * inline [
//and you want to remove 4, 6, and 7
Right keep (t)
load key resident t
not match(key, 4, 6, 7);
DROP Table t2;
I think, join should do the work also without dropping table...
inner join (t)