Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
petter
MVP
MVP

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?

jonathandienst

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
PrashantSangle

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.
mahesh_agrawal
Creator
Creator

Hi,

See the attached File. Hope it helps.

Cheers,

Mahesh

Not applicable
Author

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