topic Re: Loading an Excel Workbook having multiple sheets in QlikView

Loading an Excel Workbook having multiple sheets

Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Loading an Excel Workbook having multiple sheets

tyagishaila — Fri, 12 May 2017 09:00:03 GMT

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

Re: Loading an Excel Workbook having multiple sheets

Anonymous — Fri, 12 May 2017 09:09:24 GMT

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

Re: Loading an Excel Workbook having multiple sheets

beck_bakytbek — Fri, 12 May 2017 09:14:33 GMT

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

Re: Loading an Excel Workbook having multiple sheets

Kushal_Chawda — Fri, 12 May 2017 09:18:42 GMT

see this

Dynamically Loading Multiple Excel Files

Re: Loading an Excel Workbook having multiple sheets

Fri, 12 May 2017 09:32:54 GMT

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