Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;