Loading QVD's in a folder

gaurav2017 — Wed, 22 May 2013 09:30:41 GMT

Hi,

Scenario:

I am having 6 QVD's

P_Employee.QVD

P_Customer.QVD

P_Vendor.QVD

P_Sales.QVD

P_CustomerContact.QVD

I want to load all QVD's but without loading a specific QVD in a folder (i.e. P_Vendor.QVD). for this, I wrote a code given below:

LOAD *

FROM

$(RawQvdPath)\P*.QVD

(qvd) Where FileName() <> 'P_Vendor.QVD';

The problem:

I am able to see it in the Table Viewer. Please suggest, how i make QV doesn't consider it.

Regards,

Re: Loading QVD's in a folder

Wed, 22 May 2013 12:05:51 GMT

Try this approach:

for each File in filelist ('$(RawQvdPath)\*.qvd')

LET vTableName = Subfield(Subfield('$(File)', '\', SubstringCount('$(File)', '\') + 1), '.', 1);

if $(vTableName) <> "P_Vendor" then

$(vTableName):

LOAD * FROM $(File) (QVD);

end if

nextFile

Regards