Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
LOAD ID%, BARCODE, TYPE, NUMBER
(ooxml, embedded labels, header is 1 lines, table is Foglio1)
where len(trim(ID%)) > 0;
NoConcatenate load *
TYPE <> 'DOM'
or ((TYPE = 'DOM') and (Peek(ID%) <> ID% or Peek(TYPE)<>TYPE))
order by ID%, TYPE, NUMBER desc;
DROP Table source;
Here is solution.
Thank you very much, it's very good, but Massimo's solution it's simpler for my purpose.
Thank you to both!