Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JSK
Contributor
Contributor

Multiple Microsoft Excel data sheet - Data source

How to pull data from multiple excel sheet or multiple tabs as a Data source in Qlikview?

Labels (1)
1 Reply
Mattia
Creator II
Creator II

Hi JSK,

you can upload different sheets of the same excel file.

Follow this path: FILE - EDIT SCRIPT - TABLE FILES - choose your excel file - choose your sheet in TABLES (there is a drop down menù).

If the tables/sheets that you upload have the same set of fields and the fields have the same name, QV automatically concatenate the tables/data even if the source is different (the second table is treated as a continuation of the first).

Hope this helps.

Mattia