Load Multiple files and save as qvd

[katetsan]

Hi Communities,

How can I load the multiple excel files and save each file as qvd?

I've tried the scripts as below and have saved the files as qvd. However, the file size of qvd is accumulated as attached image 2.

Is there anyone could help me up?

Thanks in advanced

*** Script ***

Let vPath = 'd:\Users\katetsan\Documents\產品損益表\產品損益_ERP\Data\DataSource';

Let vSavePath = 'd:\Users\katetsan\Documents\產品損益表\產品損益_ERP\Data\QlikOutput\';

     For Each vFile in FileList('$(vPath)\*.xlsx');

          Data:

          LOAD

          FileBaseName() as FileName,

          *

          FROM

          [$(vFile)]

          (ooxml, embedded labels, table is 工作表1);

     Let vFileName = peek('FileName');

     Store Data into '$(vSavePath)$(vFileName)'.QVD(qvd);

     Next

*** Script ***

[prma7799]

Please check this

https://community.qlik.com/thread/61585

Loading Multiple Excel files to QlikView | Qlik Community

[katetsan]

Hi,

Thanks for your reply.

I add a "Drop Table " script, and the problem is solved.

*****Script*****

....

Drop Table Data;

Next

*****Script*****

Thanks a lot!

[prma7799]

Please close this thread as marking helpful or correct answer.

Thanks