Multiple Microsoft Excel data sheet - Data source

[JSK]

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

[Mattia]

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