topic Count OrderId during Load in QlikView

Count OrderId during Load

Tue, 29 Jun 2010 09:33:44 GMT

Hi all

I would like during the scrip-load know if the OrderId change. (comparing the previsus record value "OrderId" )

I Know that my script is wrong, but i would like obtain something similar:

Let vOrder='XXXXX';

LOAD *;

let vOrder = OrderId;

LOAD *,

if($(vOrder)<>OrderId, 1 ,0 ) as CountOrder;

SQL SELECT *

FROM LIBRARY.ORDERLINE;

Thank you for your attention

Regards

Claudio

sparur — Tue, 29 Jun 2010 09:44:13 GMT

Hello, Claudio.

try something like this:

LOAD *,

IF (peek(OrderId) <> OrderId, 1, 0) as CountOrder

;

SQL SELECT *

FROM LIBRARY.ORDERLINE

ORDER BY OrderId;

Tue, 29 Jun 2010 09:58:52 GMT

Many Thanks for your reply:

is there another solution without use group by, I have 100 million records and group by is too slow ?

sparur — Tue, 29 Jun 2010 10:01:17 GMT

I don't use a GROUP BY statement. I use ORDER BY

Tue, 29 Jun 2010 10:50:02 GMT

Sorry work perfectly

Many Many Thanks