topic Load distinct according to two values in QlikView

Load distinct according to two values

cosmicyes — Sat, 16 Nov 2024 19:57:06 GMT

Hi,

this might not be too difficult but I cannot find out how to do this.

In a load-statement I want to just load the first record where the values "OrderNo" AND "Pos" are distinct.

Example:

OrderNo, Pos, pc, val
123,3,5,10
123,3,6,15

should only load the first record.

Thank you in advace for any hint.

Re: Load distinct according to two values

Frank_Hartmann — Mon, 07 Oct 2019 09:30:44 GMT

try like this:

Temp: Load * Inline [ OrderNo, Pos, pc, val 123,3,5,10 123,3,6,15 234,4,5,20 234,6,4,23 345,2,3,44 ]; NoConcatenate table1: LOAD * Resident Temp Where OrderNo<>Previous(OrderNo) and Pos<>Previous(Pos) Order By OrderNo, Pos, pc, val; DROP Table Temp;