Grouping

[dunnalahk123]

Hi,

i am trying to get  "Grouprowno"  by grouping at project level.

so if one project ID  has 3 timestamps  then my Grouprowno i am getting as 1, 2 and 3 .  as per below.

but from below tables Group row field should give me 1 where timestamp is higher and then 2 for second higher time stamp and so on. so how can i write ?

this is what my script i wrote to get above table output  and now i want to modify accordingly higher timestamp should get 1 and second higher timestamp should get 2 then so on for GroupRow field. how can i modify my below scripting?

Temp:

LOAD

Rowno,
[Project ID],
[HOLD Closure date],
[PSA Project pse Project ID]
FROM
[$(QVD_Path_CD)\D1.qvd](qvd);

NoConcatenate

GSDHOLDClosuredate1:

LOAD
Rowno,
[Project ID],
[HOLD Closure date],
[PSA Project pse Project ID],
IF([PSA Project pse Project ID]<> Previous([PSA Project pse Project ID]), 1, Peek('GroupRow')+1) AS GroupRow

Resident Temp
Order By [PSA Project pse Project ID], [HOLD Closure date]

;

drop table Temp;

STORE GSDHOLDClosuredate1 into [$(QVD_Path_CD)\D1Base.qvd];

exit script;