topic Re: Dynamic Data Source Load into QlikView and create QVD? in QlikView

Dynamic Data Source Load into QlikView and create QVD?

naziralala — Sat, 10 Jan 2015 22:12:41 GMT

Hi Everyone,

I am assigned a project, which involves loading data from multiple excels having same tabs in all.

This excel data from 3 tabs need to be loaded into qlik view and create 3 qvd's.

I have to create a data load from multiple excels into these 3 qvd's, and there has to be no code change.

Currently, I have 3 excels loading data...but if they were to be 10 excels, 25 excels,etc?

Can someone help me in getting this logic and code...

Re: Dynamic Data Source Load into QlikView and create QVD?

jonasheisterkam — Sun, 11 Jan 2015 00:23:41 GMT

Hi,

to adress more Files in one Load you can use the * wildcard.

You can use the Filelist, in the help you find a sample with a for each loop.

Some other functions you can use are the sql connect to excel files to read metadata.

With error mode you can use the wildcards also if there are fail pos loads witch generates errors.

You can use a load in the loop to generate a variable wich define the real load syntax for each file. With this you can react on some differences in the sources.

Re: Dynamic Data Source Load into QlikView and create QVD?

MarcoWedel — Sun, 11 Jan 2015 00:52:52 GMT

tabSheet1:
LOAD *
FROM path\*.xlsx
(ooxml, embedded labels, table is sheet1);

tabSheet2:
LOAD *
FROM path\*.xlsx
(ooxml, embedded labels, table is sheet2);

tabSheet3:
LOAD *
FROM path\*.xlsx
(ooxml, embedded labels, table is sheet3);

Store tabSheet1 into tabSheet1.qvd (qvd);
Store tabSheet2 into tabSheet2.qvd (qvd);
Store tabSheet3 into tabSheet3.qvd (qvd);

hope this helps

regards

Marco

Re: Dynamic Data Source Load into QlikView and create QVD?

naziralala — Mon, 27 Apr 2015 15:50:48 GMT

Thanks. This helped.