Creation of qvds using for loop in qlikview

[#1]

Hi all,

I am new to Qlik view.I like to know how can i create Qvds using for loop.

for example i am having 20 Exel files in D;//,so i want these 20 files into qvd.

can u please share me the script for the above scinario. it will be helpfull to me.

regards

theja

[jagan]

Hi Theja,

If you are having different data in files, for example Budget, Revenue then you have load like this

Budget:

LOAD

*

FROM Budget*.xls;

Revenue:

LOAD

*

FROM Acutal*.xls;

or if all excel files are not same then you have use loop to reload or load statement for each excel file separately.

Regards,

jagan.