topic Re: Load specific qvd files dynamically from folder in QlikView

Load specific qvd files dynamically from folder

vikasmahajan — Fri, 20 May 2016 12:56:33 GMT

Dear All,

I have qvd's into folder with following table , I want to skip 8 files , and want to load other all qvds dynamically.

list of qvds.

ABC.qvd

Hierarchy.qvd

AssestTracking.QVD

Top_Down_Hierarchy.qvd

UnusedDatabases.qvd

VirtualizationResize.qvd

LowUtil.qvd

IOSAN.qvd

Please suggests.

Thanks

Vikas

Re: Load specific qvd files dynamically from folder

tamilarasu — Fri, 20 May 2016 13:17:03 GMT

Hi,

You can try like below,

ExceptionList:
Load Concat(Chr(39) & Name & Chr(39),', ') as FileList;
LOAD * INLINE [
    Name
    File1
    File2
    File3
    File4
    File5
];

LET vFileList = Peek('FileList');

DROP Table ExceptionList;

Data:
LOAD *,
Filebasename() as FileName FROM

(qvd) Where Not Match(FileBaseName(), $(vFileList));

You can also use excel file instead of Inline load.

Re: Load specific qvd files dynamically from folder

vikasmahajan — Mon, 23 May 2016 06:34:11 GMT

Thanks Tamil I will check n get back you.

Vikas