topic Re: qvd create time and qvd names in QlikView

qvd create time and qvd names

hari8088 — Thu, 16 Apr 2015 09:41:29 GMT

Hi all.

I have one path(system path) in that path lot of qvds are there for example 10 qvds are there .with the help of path i want to find qvd names and qvd create time.

Any suggestions..

Thanks......

Re: qvd create time and qvd names

ashfaq_haseeb — Thu, 16 Apr 2015 09:54:37 GMT

Hi,

Try like this

LOAD

filebasename() as Name,

FileTime() as Time

FROM

*.qvd(qvd);

Regards

ASHFAQ

Re: qvd create time and qvd names

MK_QSL — Thu, 16 Apr 2015 10:16:44 GMT

Let vQVDPath = 'C:\Users\QVD';

For Each File in FileList(vQVDPath& '\*.qvd')

Load

FileName() as TableName

,FileTime() as FileCreateTime

,QvdCreateTime('$(File)') as QVDCreateTime

,SubField(SubField('$(File)','\',-1),'.',1) as QVDTableName

From [$(File)] (qvd);

Next File

Re: qvd create time and qvd names

Gabriel — Thu, 16 Apr 2015 11:03:07 GMT

Hi,

Have you tried MRKachhiaIMP suggestion yet?

Re: qvd create time and qvd names

Peter_Cammaert — Thu, 16 Apr 2015 11:25:55 GMT

Have you?

Same problem as with Ashfaq's code: a LOAD creates a file details-row for every single record in every single QVD. Imagine that the first QVD contains 1000000 rows. Then your scan of the first QVD will store 1000000 identical rows in your resident table.

Re: qvd create time and qvd names

hari8088 — Thu, 16 Apr 2015 13:23:15 GMT

I tried What Manish Kachhin suggested it is warking fine

thankyou

Re: qvd create time and qvd names

hari8088 — Thu, 16 Apr 2015 13:24:37 GMT

This code is warking fine.

thank you...........

Re: qvd create time and qvd names

Peter_Cammaert — Thu, 16 Apr 2015 13:26:30 GMT

How many rows do you have in the resulting table? (check Settings->Document Properties->Tables and select the QVD details line in the upper overview) And how many QVD's in your directory?

Re: qvd create time and qvd names

MK_QSL — Thu, 16 Apr 2015 13:59:14 GMT

If you got your answer, kindly close the thread by selecting correct/helpful answer, so that others having same problem can take advantage of this thread.,.