How to delete some records

[Anonymous]

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]

Hi,

Here is solution.

Regards,

Kaushik Solanki

[maxgro · Accepted solution]

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]

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

Thank you to both!

Elena