Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I drop a row if a field value is a certain value in that row?
if you like to do it during reload, you may exclude those rows using "where" clause
regards
Darek
if you like to do it during reload, you may exclude those rows using "where" clause
regards
Darek
there isn't a (like sql)
delete .... from ... where ....
in qlikview
if you don't want a row you exclude it during the load (as Dariusz said)
//or if you have a table t
t:
load * inline [
key, f1
1,100
2,200
3,100
4,100
5,300
6,100
7,700
]
;
//and you want to remove 4, 6, and 7
t2:
Right keep (t)
load key resident t
where
not match(key, 4, 6, 7);
DROP Table t2;
I think, join should do the work also without dropping table...
t:
load * inline [
key, f1
1,100
2,200
3,100
4,100
5,300
6,100
7,700
];
inner join (t)
load key resident t
where
key >5;