Discussion board where members can get started with QlikView.
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, val123,3,5,10123,3,6,15
should only load the first record.Thank you in advace for any hint.
try like this:
Load * Inline [
OrderNo, Pos, pc, val
LOAD * Resident Temp
Where OrderNo<>Previous(OrderNo) and Pos<>Previous(Pos)
Order By OrderNo, Pos, pc, val;
DROP Table Temp;
View solution in original post