topic Re: How to get specific qvds date time in QlikView

How to get specific qvds date time

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using below script for getting the qvd's updated time but in my path there are n-numbers of qvds are there I want some specific qvds date n time I have tried to add below code but its not working?

Let vQVDPath = '....\qvd';

LOAD QVD_NAMES AS QVDTableName

FROM

[QVD_List.xlsx]

(ooxml, embedded labels, table is Sheet1);

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

Regards,

New to QlikView‌

Re: How to get specific qvds date time

Colin-Albert — Mon, 25 Sep 2017 14:53:47 GMT

Let vQVDPath = '....\qvd'; is this line correct?

Should it be Let vQVDPath = '..\qvd'; or Let vQVDPath = '..\..\qvd';

Try adding trace commands to see if your variables are being created correctly, and enable the document log

Also add $() around vQVDPath to force the variable to be evaluated.

trace FilePath is [$(vQVDPath) & '\*.qvd')] ;

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

trace File is [$(File)] ;

Load

FileName() as TableName

,FileTime() as FileCreateTime

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

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

From [$(File)] (qvd);

Next File

Re: How to get specific qvds date time

Karim_Khan — Tue, 26 Sep 2017 07:43:03 GMT

Colin Thanks for your reply but my concern is for exists clause use with in line file.

Re: How to get specific qvds date time

prieper — Tue, 26 Sep 2017 07:49:50 GMT

Do you need only the info of the files from your Excel-List? Then the second part is misleading.

Try (aircode):

FOR i = 0 TO NOOFROWS('A') -1

LET sFile = PEEK('QVDTableName', i, 'A');

TableInfo:

LOAD

FILENAME('$(sFile)') AS TableName,

FILETIME('$(sFile)') AS FileCreateTime,

..... etc

NEXT i

Re: How to get specific qvds date time

Karim_Khan — Tue, 26 Sep 2017 08:37:27 GMT

Hi Peter,

have tried ur code also but after that excel code is not getting executed

LOAD QVD_NAMES

FROM

[\.....\QVD_List.xlsx]

(ooxml, embedded labels, table is Sheet1);

FOR i = 0 TO NOOFROWS('A') -1

LET sFile = PEEK('QVDTableName', i, 'A');

TableInfo:

LOAD

FILENAME('$(sFile)') AS TableName,

FILETIME('$(sFile)') AS FileCreateTime;

NEXT i

Re: How to get specific qvds date time

prieper — Tue, 26 Sep 2017 09:04:39 GMT

What is not working?

Does the Excel have complete pathnames?

Re: How to get specific qvds date time

prieper — Tue, 26 Sep 2017 09:05:45 GMT

Also the PEEK has to refer to the name in the Excel, i.e. QVD_NAMES

Re: How to get specific qvds date time

Kushal_Chawda — Tue, 26 Sep 2017 09:26:32 GMT

how values look like in QVD_NAMES excel file.. is it Qvdname.qvd or just Qvdname?

Re: How to get specific qvds date time

Colin-Albert — Tue, 26 Sep 2017 09:40:00 GMT

You refer to "exists" and "inline" in your reply, but your example script does not use a "Where exists" clause nor an inline load. Can you clarify?

Have you tried stepping through your load script using Debug mode?

This would help as it would expand each line to show how the variables re being expanded and would identify which line of the script is erroring.

Can you then come back with any specific errors rather than simply saying "it is not working".

Which line is erroring?

Does the vQVDPath variable hold the expected value?

Does the File variable hold the correct filenames?

Are the fields QVDCreateTime, QVDTableName etc. holding valid data?

Re: How to get specific qvds date time

Karim_Khan — Tue, 26 Sep 2017 09:43:04 GMT

I had missed path sorry

Re: How to get specific qvds date time

Karim_Khan — Tue, 26 Sep 2017 09:43:27 GMT

I had missed path sorry rest is fine

Re: How to get specific qvds date time

Karim_Khan — Tue, 26 Sep 2017 09:43:35 GMT

I had missed path sorry