Load data from multiple sheets from an excel

[udaya_kumar]

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]

Check this out: EXCEL SHEETS

[gautik92]

click on table files select the sheet and finish

[#4]

See this link

Load multiple sheets and excel files

[jonathandienst · Accepted solution]

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]

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