Issues loading multiple Excel files

[#1]

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.

[#2]

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.

[#3]

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

[#4]

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.

[#5]

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.

[#6]

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   .