Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pulling multiple excel sheets into QV when all headings are the same

Hello all,

Please forgive me if this question has a simple answer, I couldn't find an exact answer after searching the forums.

Basically we keep various financial data in an excel spreadsheet for one of our major accounts, with each tab being that years data (2002, 2003 etc. up to 2013). In each tab the headings are the same.

I am looking to use Qlikview to manipulate that data and produce various reports, which I have had success with using just the most recent data. However, pulling the other sheets into the script editor is causing the table viewer to link every entry (as the headings are the same) making the program become very slow and occasionally crashing.

I have tried uploading them separately and renaming the headings but that doesn't allow me properly manipulate the data.

Is there an easy way to pull the data into the script editor/Qlikview from multiple sheets?

Thank you

12 Replies
Not applicable
Author

I am out of the office until 12/11/2013.

My emails will be read upon my return. If your enquiry is urgent please

forward your email to the following inboxes:

For all Marine Cargo queries please forward your emails to

regionalcargo.claims@uk.rsagroup.com.

For all other queries please forward your email to

daniel.shaw@uk.rsagroup.com.

Note: This is an automated response to your message "Re:

- Pulling multiple excel sheets into QV when all headings are the same"

sent on 02/11/2013 6:28:04.

This is the only notification you will receive while this person is away.

Please consider the environment - Think before you print

RSA -The UK's first carbon neutral insurer

*********************************************************************************************************************************************************************************

Royal & Sun Alliance Insurance plc (No. 93792). Registered in England & Wales at St. Mark's Court, Chart Way, Horsham, West Sussex, RH12 1XL.

Authorised and Regulated by the Financial Services Authority. For your protection, telephone calls may be recorded and monitored. The information

in this e-mail is confidential and may be read, copied or used only by the intended recipients. If you have received it in error please contact the

sender immediately by returning the e-mail. Please delete the e-mail and do not disclose any of its contents to anyone. No responsibility is accepted

for loss or damage arising from viruses or changes made to this message after it was sent.

preminqlik
Specialist II
Specialist II

tab:

load

filebasename()         as               filename,

*

from

c:/path/*;

keep your files in path folder in above eg...

suppose if you have to choose only some files  examplefile names are starting with "Year-XXXX" then use below syntax

load

num(right(filebasename(),4) )            as          Year,

*

from c:/Path/Year*;

hope this helps you

Regards

Premhas.

Not applicable
Author

I am out of the office until 12/11/2013.

My emails will be read upon my return. If your enquiry is urgent please

forward your email to the following inboxes:

For all Marine Cargo queries please forward your emails to

regionalcargo.claims@uk.rsagroup.com.

For all other queries please forward your email to

daniel.shaw@uk.rsagroup.com.

Note: This is an automated response to your message "Re:

- Pulling multiple excel sheets into QV when all headings are the same"

sent on 02/11/2013 9:43:03.

This is the only notification you will receive while this person is away.

Please consider the environment - Think before you print

RSA -The UK's first carbon neutral insurer

*********************************************************************************************************************************************************************************

Royal & Sun Alliance Insurance plc (No. 93792). Registered in England & Wales at St. Mark's Court, Chart Way, Horsham, West Sussex, RH12 1XL.

Authorised and Regulated by the Financial Services Authority. For your protection, telephone calls may be recorded and monitored. The information

in this e-mail is confidential and may be read, copied or used only by the intended recipients. If you have received it in error please contact the

sender immediately by returning the e-mail. Please delete the e-mail and do not disclose any of its contents to anyone. No responsibility is accepted

for loss or damage arising from viruses or changes made to this message after it was sent.