Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
Need your help. I have initial QVD file format as below shows.
But I would like to get the output QVD file that only show the latest 'D Time' by 'Pdn name'.
Expected result:
Thanks your help.....
Hi, load incial qvd and do an inner join with the max date for each pdn to keep only those files, somewhat like:
Data:
LOAD * From [Path\qvdname.qvd](qvd);
Inner Join (Data)
LOAD [Pdn name],
max([D Time) as [D Time]
resident Data
Group By [Pdn name];
Store Data into ReducedQvdName.qvd(qvd);
Hi, load incial qvd and do an inner join with the max date for each pdn to keep only those files, somewhat like:
Data:
LOAD * From [Path\qvdname.qvd](qvd);
Inner Join (Data)
LOAD [Pdn name],
max([D Time) as [D Time]
resident Data
Group By [Pdn name];
Store Data into ReducedQvdName.qvd(qvd);
Hi Rubenmarin:
Thank you very much for solution.
Regards,
aminqlik