Count OrderId during Load

[#1]

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]

Hello, Claudio.

try something like this:

LOAD *,

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

;

SQL SELECT *

FROM LIBRARY.ORDERLINE

ORDER BY OrderId;

[#3]

Hi

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 · Accepted solution]

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

[#5]

Sorry work perfectly

Many Many Thanks