topic Re: Loading multiple Excel taking long time in QlikView

Loading multiple Excel taking long time

Mon, 05 Oct 2015 05:09:20 GMT

Hi All,

I am loading multiple excel sheets to my Qlikview document. the excels are of same format and have same field names, bu with different sheet names. I am loading all the files separately and it takes lot of time to load the files. Is there a better way to load excel to Qliview and to reduce the reload time.

Regards,

Saritha Xavier.

Re: Loading multiple Excel taking long time

petter — Mon, 05 Oct 2015 05:14:00 GMT

Could you tell us what "lot of time" is. How many Excel sheets are you loading and how many workbooks? What is the size of each spreadsheet - in rows, columns and bytes. Is it the old XLS format or the new XLSX format?

Re: Loading multiple Excel taking long time

jonathandienst — Mon, 05 Oct 2015 05:33:35 GMT

You need to provide more information if you want useful help. How are you loading them, how many fields, how many columns, any special format. A load script and a sample of one of the files would also help us help you.

Re: Loading multiple Excel taking long time

PrashantSangle — Mon, 05 Oct 2015 05:35:18 GMT

Hi,

are all fields necessary??

Take only those field which are necessary.

How many data inside within 1 xls file and how many xls are there??

Regards

Re: Loading multiple Excel taking long time

mahesh_agrawal — Mon, 05 Oct 2015 09:06:47 GMT

Hi,

See the attached File. Hope it helps.

Cheers,

Mahesh

Re: Loading multiple Excel taking long time

Mon, 05 Oct 2015 10:43:42 GMT

Hi,

Below is how i load the data from excel.

LOAD ID,

[Month Year]

Num(Hours,'#,###.00') as Hours,

Num(Dollars,'$#,##0.;($#,##0.)') as Dollars,

[Initiative ID],

[op Area]

FROM

[Payroll_FY13.xlsx]

(ooxml, embedded labels, table is FY13)

Where Match([Initiative ID],'SB')

and Match([op Area],'Lab')

and 1-Sign(Match([Reg/OT],'Not Applicable'))

and num(Date#([Month Year],'YYYY-M'))>= '$(vMonthStart)'