Dropping items

[Anonymous]

How do I drop a row if a field value is a certain value in that row?

[#2 · Accepted solution]

if you like to do it during reload, you may exclude those rows using "where" clause

regards

Darek

[maxgro]

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;

[#4]

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;