topic How to delete some records in QlikView

How to delete some records

Anonymous — Sat, 13 Jun 2015 10:06:16 GMT

Hi!

I have a question regarding delete records during the load, based on the type of some attributes.

Please find attached data and the precise question.

Thanks!

Elena

kaushiknsolanki — Sat, 13 Jun 2015 10:46:31 GMT

Hi,

Here is solution.

Regards,

Kaushik Solanki

maxgro — Sat, 13 Jun 2015 11:18:20 GMT

Directory;

source:

LOAD ID%, BARCODE, TYPE, NUMBER

FROM

sampledata.xlsx

(ooxml, embedded labels, header is 1 lines, table is Foglio1)

where len(trim(ID%)) > 0;

final:

NoConcatenate load *

Resident source

where

TYPE <> 'DOM'

or ((TYPE = 'DOM') and (Peek(ID%) <> ID% or Peek(TYPE)<>TYPE))

order by ID%, TYPE, NUMBER desc;

DROP Table source;

Anonymous — Mon, 15 Jun 2015 18:24:44 GMT

Thank you very much, it's very good, but Massimo's solution it's simpler for my purpose.

Thank you to both!

Elena