Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gaurav2017
Contributor 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

Re: Loading QVD's in a folder

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

Community Browser