Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
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)'