How to delete multiple lines Using keep

[#1]

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);

[hic · Accepted solution]

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

[#3]

thanks a lot Mr.Henric

My problem was solved with your suggestion.