Loading multiple Excel taking long time - Qlik Community

Report Inappropriate Content · ‎2015-10-05

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.

petter · ‎2015-10-05

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 · ‎2015-10-05

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 · ‎2015-10-05

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 · ‎2015-10-05

Hi,

See the attached File. Hope it helps.

Cheers,

Mahesh

Report Inappropriate Content · ‎2015-10-05

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