topic Re: How to delete multiple lines Using keep in QlikView

How to delete multiple lines Using keep

Wed, 25 Mar 2015 20:31:03 GMT

Hi,

Here my Concern is in this below table,The lines 11 and 12 have no data so i want to delete the multiple lines at a time by using keep,,

Although im using this below to delete for single Table:

Cs:

LOAD CustomerID,

SalesOrderID,

ProductID,

SalesAmount,

OrderQty,

Year

FROM

(ooxml, embedded labels, table is [Fact Table])

Where ProductID<>11;

Prod:

right Keep LOAD ProductID,

ProductName

FROM

(ooxml, embedded labels, table is Product);

Re: How to delete multiple lines Using keep

hic — Wed, 25 Mar 2015 21:13:59 GMT

I think you want to use

... Where OrderQty>0 ;

instead of hard-coding a ProductID.

Secondly, I would use a Left Keep instead. Then you keep the records in the first table loaded according to the where-clause, and remove records in the second table - records that have no counterpart in the first table.

HIC

Re: How to delete multiple lines Using keep

Thu, 26 Mar 2015 08:32:37 GMT

thanks a lot Mr.Henric

My problem was solved with your suggestion.