Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a folder in which there are various qvd files.
On my dashboard, i wish to show the last refresh time of various qvds.
Please help.....
Hi,
Try like this
Payroll:
LOAD *
QvdCreateTime(FileDir() & '\'&FileName()) as LastRefreshTime
FROM
FileName.qvd;
Regards,
Jagan.
Hi Asma,
you can use the below sript.
for each v_qvd in 'c:\QVD\*.qvd (replace with qvd path)
let vTime=QvdCreateTime($(v_qvd);
QVD_Time:
Load * inline[time, QVD
$(vTime),$(v_qvd)
];
next
Table QVD_Time contains the list of QVD with the refresh time.
This is to get the latest refreshed qvd if you need
LatestQVD:
Load Max(time) as MaxTime,QVD
resident QVD_Time;
letv_latestQVD=peek(MaxTime,'LatestQVD');
see attached
Regards
Thanks everyone for such a quick response!!!!!