loading multiple tables data from single excel sheet tab

[anat]

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]

Try this: Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[Chanty4u]

chk dis

Load Multiple excel sheets using For loop

[anat]

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

[anat]

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

[Anonymous]

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]

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]

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