Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anavin33
New Contributor II

Dropping items

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

1 Solution

Accepted Solutions
Not applicable

Re: Dropping items

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

regards

Darek

3 Replies
Not applicable

Re: Dropping items

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

regards

Darek

MVP
MVP

Re: Dropping items

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;

Not applicable

Re: Dropping items

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;

Community Browser