topic Dropping items in QlikView

Dropping items

Anonymous — Wed, 04 Jun 2014 20:06:05 GMT

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

Re: Dropping items

Wed, 04 Jun 2014 20:14:51 GMT

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

regards

Darek

Re: Dropping items

maxgro — Wed, 04 Jun 2014 20:44:17 GMT

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

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;

Re: Dropping items

Wed, 04 Jun 2014 20:53:12 GMT

I think, join should do the work also without dropping table...

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;