how to upload a data from various excels of upto 288 mb into qlikview desktop

[#1]

how to upload a data from various excels of upto 288 mb into qlikview desktop

[ashfaq_haseeb]

Hi Shivali,

Can you elaborate more?

What are you trying to achieve? Is that you wanna load data from multiple excels or you want to load data upto 288 MB only from single excel.

Regards

ASHFAQ

[its_anandrjs]

As i understand you need to load all files at once in single load or if they are same fields then load it like

Load

*

FROM

(ooxml, embedded labels, table is [Sheet1]);

[#4]

i have in total 288 mb data which is of multiple excels and in one excel sheets there are further subsheets

[#5]

yes i need to load in a single go but the fields name are nt same

[ashfaq_haseeb]

If you have different field structure it would be a bit difficult.

Go thought the below post.

http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html

Regards

ASHFAQ

[its_anandrjs]

Then try with this code

LOAD *,  FileName() as ExcelFileNames

FROM

[YourLocationHere\*.xlsx]

(ooxml, embedded labels, table is [$(*)]);

Note:- If they are xls file then change it to *.xls if not then *.xlsx also if in any sheet there is same field name or in any file same fields then you get synthetic keys in the data model i suggest create individual qvd of this files and then use it in the model creation.