Load specific qvd files dynamically from folder

[vikasmahajan]

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

[tamilarasu]

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.

[vikasmahajan]

Thanks Tamil I will check n get back you.

Vikas