Loading QVD's in a folder

[gaurav2017]

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,

[#2]

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