Loading an Excel Workbook having multiple sheets

[#1]

Hi,

I want to load an excel workbook which has multiple sheets.

Could anyone please help as I tried already posted solutions but they didn't seem to work for me.

(P.S. - I have attached the excel I want to load)

[tyagishaila]

Like this-

FOR EACH vMonth IN 'APR','MAY','JUN','JUL','AUG,'SEP','OCT'

Tab1:

LOAD *

FROM

[ExcelFile.xlsx]

(ooxml, embedded labels, table is $(vMonth));

NEXT

[Anonymous]

Hi Saumya,

I'm guessing you mean the excel sheet has the multiple tables at the bottom to separate your sheets? and you want to pull them all in? If so, you do this via the data load editor as shown below:

Tick the highlighted sections to choose which sheets you want to pull in

[beck_bakytbek]

Hi Saumya,

the suggestion of Shaila Tyagi is correct, but dont forget your fields within each table must be the same, for instance:

in tab 'Apr' you have 2 Fields: Country, Year, this means that in tab: 'May' you must have 2 Fields as: Country and Year as well.

look at this:

1.Load the sample data - How to manage the QlikView data model - Part 1 - YouTube

2.Cross Table in QlikView - YouTube

i hope that helps

Beck

[Kushal_Chawda]

see this

Dynamically Loading Multiple Excel Files

[#6]

Thanks for your suggestion guys...will try and let you know.