Dates in Descending Order in loading script

dunnalahk123 · ‎2022-02-22

Hi,

can some can help here i want all my dates in Descending Order always at project level

I wrote below Script

Temp2:

LOAD

PSA_Project_Internal_Id as [Project ID],
'' as [HOLD Closure date2],

(Date(Floor( [Created_Timestamp]),'MM/DD/YYYY')) as [HOLD Closure date]

FROM
[$(ITG_QVD_Path)\GSD_PSA_Project_History.qvd]
(qvd)
where (Field_Text= 'pse__Project_Status__c' AND (Old_Value_Text='On Hold')) ;

NoConcatenate

GSDHOLDClosuredate:

LOAD

[Project ID],
[HOLD Closure date],

Resident Temp2

Order by [HOLD Closure date] Desc;

drop table Temp2;

for above script i got below output

but i need dates in descending order like below

first 11/04/2020

10/12/2020

06/01/2020

whiling loading in script itself .

how can i write?

AnalyticsBoost · ‎2022-02-23

You are missing the statement: group by [HOLD Closure date]

First you need to do group by and second the order by