Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Loading multiple Excel taking long time

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.

5 Replies
MVP
MVP

Re: Loading multiple Excel taking long time

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?

MVP
MVP

Re: Loading multiple Excel taking long time

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Re: Loading multiple Excel taking long time

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

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
mahesh_agrawal
Contributor

Re: Loading multiple Excel taking long time

Hi,

See the attached File. Hope it helps.

Cheers,

Mahesh

Not applicable

Re: Loading multiple Excel taking long time

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)'