Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Loading QVD's in a folder

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,

1 Reply
Not applicable

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