Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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
Highlighted
Contributor II

Re: Multiple Microsoft Excel data sheet - Data source

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