topic Re: Load Multiple sheets in a single excel data source in QlikView

Load Multiple sheets in a single excel data source

Anonymous — Thu, 13 Aug 2015 13:44:46 GMT

Hi Friends,How to Load an Excel data source which is having multiple sheets in a single Excel data source.

All Regions Tab in data source has same set of data i.e., column names and Fields are same we can concatenate as a single Sheet and need help on these.

Re: Load Multiple sheets in a single excel data source

MK_QSL — Thu, 13 Aug 2015 13:53:26 GMT

Load multiple excel files from Multiple excel sheetsinto QV

Import multiple sheets in excel

Load multiple sheets and excel files

Re: Load Multiple sheets in a single excel data source

Thu, 13 Aug 2015 14:12:51 GMT

Hai Swethasmilek

Rename the Four Sheets as A1,A2,A3,A4 then in script pane write the below code

FOR VCOUNT=1 TO 4

LOAD [Address Number],

[Business Family],

[Business Unit],

Customer,

[Customer Number],

[Customer Type],

Division,

[Line of Business],

Phone,

[Region Code],

[Regional Sales Mgr],

[Search Type]

FROM

(ooxml, embedded labels, table is A$(VCOUNT));

Re: Load Multiple sheets in a single excel data source

Anonymous — Thu, 13 Aug 2015 14:16:57 GMT

It was given by Business People it cant be renamed.other then renaming can you help on variables with loop