Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to upload a data from various excels of upto 288 mb into qlikview desktop
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
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]);
i have in total 288 mb data which is of multiple excels and in one excel sheets there are further subsheets
yes i need to load in a single go but the fields name are nt same
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
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.