topic Re: loading multiple tables data from single excel sheet tab in QlikView

loading multiple tables data from single excel sheet tab

anat — Wed, 13 Apr 2016 11:20:43 GMT

Hi,

i am having 1 excel sheet tab which contain 5 to 6 tables, how to load all these tables data in qlikview.

Regards

..........

sunny_talwar — Wed, 13 Apr 2016 11:22:08 GMT

Chanty4u — Wed, 13 Apr 2016 11:36:30 GMT

chk dis

anat — Wed, 13 Apr 2016 11:42:33 GMT

i gone through all the possible links in qlikview community but there is no correct logic to load multiple tables from single tab.

anat — Wed, 13 Apr 2016 11:44:55 GMT

hi sunny,thanks for your response , but what i want is ,i want to load multiple tables data from single excel sheet tab.

Anonymous — Wed, 13 Apr 2016 11:50:19 GMT

You'll probably need to use the Transformation Wizard and create a seperate load for each table.

I have done the first one for you :

LOAD name,

id,

salary

FROM

sample.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 10)),

Remove(Row, Pos(Top, 9)),

Remove(Row, Pos(Top, 8)),

Remove(Row, Pos(Top, 7)),

Remove(Row, Pos(Top, 6))

));

However problems may well arise if the exact format of the spreadsheet changes.

stabben23 — Wed, 13 Apr 2016 11:52:57 GMT

Use the wizard to transform Your document. You need to use it for every New table you want to load from Your Excel tab.

trdandamudi — Wed, 13 Apr 2016 12:08:05 GMT

I think wizard (Transformation) step should help you in this regard.