To find Sum of changes in Orders

[#1]

Hello Guys,

I need your help.

I have a table like this

table1:

Load Ordernr,

Matnr

from x.qvd(qvd)

order by

Ordernr;

I need first to verify if a ordernr is equal to previous order in the table. If it is same then the Total Nr of changes = 0 and if it changes in comparision to previous it must be 1

I need at the end the sum of changes in my orders for a specified week or Month.

Any ideas??

Thanks in advance

[fernandotoledo]

You shoud try Previous() as follows:

ORDER_TMP:
LOAD
 ORDERNR,
 MATNR
FROM X.QVD (QVD);

ORDER:
LOAD
 ORDERNR,
 MATNR,
 IF(ORDERNR = PREVIOUS(ORDERNR),0,1) AS ORDER_CHANGE
RESIDENT ORDER_TM;

DROP TABLE ORDER_TMP;