topic qvd creation time in QlikView

qvd creation time

prabhas277 — Thu, 16 Apr 2015 13:05:44 GMT

Hi experts,

let us assume i have qvd that is stored in one path. now i want load that path by using inline and find the qvd name and qvd creation time.

see this

load * inline

[

path

E:\QV

];

using this i want to know creating time and that qvd name.

Regards,

prabhas

arthur_dom — Thu, 16 Apr 2015 13:16:04 GMT

you want to list all archives on a folder, with name, date of creation?

You could try something like:

table:

load

distinct

filename(), filetime(), filesize() from e:\qv\* (txt);

Thu, 16 Apr 2015 13:16:17 GMT

Hi Prabhas,

Try these functions,

filepath() : To fetch the path of the Table file

QvdCreateTime() : to fetch the Qvd Creation Time.

QvdTableName() :to fetch the name of the table contain in QVD.

Regards

Harsha Nandan