topic Re: Load data from multiple sheets from an excel in QlikView

Load data from multiple sheets from an excel

udaya_kumar — Wed, 18 Nov 2015 09:51:07 GMT

Hi,

I have an excel file with 5 sheets ABC1, ABC8, ABC9, ABC10, DEF.

And the data format is same in all the sheets.

I need to load all the sheets into qlikview script.

How to achieve this?

sunny_talwar — Wed, 18 Nov 2015 09:55:23 GMT

Check this out: EXCEL SHEETS

gautik92 — Wed, 18 Nov 2015 09:56:05 GMT

click on table files select the sheet and finish

Wed, 18 Nov 2015 09:56:27 GMT

See this link

jonathandienst — Wed, 18 Nov 2015 09:58:30 GMT

If the fields are identical and the sheet names do not change, then:

ForEach vSheet In 'ABC1', 'ABC8', 'ABC9', 'ABC10', 'DEF'

Data:

LOAD *

FROM MyFile.xlsx

(ooxml, table is '$(vSheet)', embedded labels);

Next

To explicitly concatenate:

Set vConcat = 'Data:';

ForEach vSheet In 'ABC1', 'ABC8', 'ABC9', 'ABC10', 'DEF'

$(vConcat)

LOAD *

FROM MyFile.xlsx

(ooxml, table is '$(vSheet)', embedded labels);

Set vConcat = 'Concatenate(Data)';

Next

Anonymous — Wed, 18 Nov 2015 10:09:55 GMT

See the attachment...

Make connection and change sheetname every time...

Also, if you are having same column name and data in all the sheet, QV will automatically concatenate all the sheet into one table

If you dont want same use nocaoncatenate in b/w tables