Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've been experiencing some issues in loading multiple excel files. The script freezes and doesn't respond when I try to do this. At the moment, I have 4 files to load into QlikView. However, if I just load one excel file, then it works fine. The files are exactly the same with the same column headings. Each seperate excel represents a different month.
Has anyone experienced similar issues?
Any help would be greatly appreciated.
Many thanks.
Rajiv.
Hi Anoush,
This script doesn't seem to work for CSV files.
i.e.
FROM
$(FileFullPath)
(txt, codepage is 1252, embedded labels, delimiter is ',' , msq);
Do I need to amend the script?
Thanks.
Rajiv.
HI Rajiv,
Use the below script. I think you haven't changed the file name extension from xls to csv. See the bold part in below script.
let filename = day(Date(startDate+i))&' '&Date(Date(startDate+i),'MMMM')&' '&YEAR(Date(startDate+i))&' - Raw Data.csv';
let filefullpath = ('
LOAD Data1,
Data2
FROM
$(filefullpath)
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
NEXT
Hope this help,
Anosh
Hi Anoush,
Thanks for getting back to me. Yes, I amended the script in the beginning, replacing .xls with .csv and it didn't seem to work.
Have you tried it the above script? Does it work?
Thanks.
Rajiv.
Hi Rajiv, Yes it is working for me. Can you attach your qvw explaining your scenario and some excel sheets to load data. I will try to debug it and check.
Hi ,
For the first sheet1 i have fields : field1, field2
and for sheet2 : field3,field4
i mean , different sheets have different fields .
is it work with your logic??????
Thanks and Regards
Satti .