topic Load Multiple files and save as qvd in QlikView

Load Multiple files and save as qvd

katetsan — Wed, 25 Nov 2020 16:16:04 GMT

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);

*** Script ***

prma7799 — Wed, 18 Oct 2017 06:37:28 GMT

Please check this

katetsan — Wed, 18 Oct 2017 07:44:50 GMT

Hi,

Thanks for your reply.

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

*****Script*****

....

Drop Table Data;

*****Script*****

Thanks a lot!

prma7799 — Wed, 18 Oct 2017 07:52:36 GMT

Please close this thread as marking helpful or correct answer.

Thanks