Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anat
Contributor

loading multiple tables data from single excel sheet tab

Hi,

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

Regards

..........

7 Replies

Re: loading multiple tables data from single excel sheet tab

Chanty4u
Esteemed Contributor III

Re: loading multiple tables data from single excel sheet tab

anat
Contributor

Re: loading multiple tables data from single excel sheet tab

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

anat
Contributor

Re: loading multiple tables data from single excel sheet tab

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

Re: loading multiple tables data from single excel sheet tab

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
Honored Contributor

Re: loading multiple tables data from single excel sheet tab

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
Honored Contributor

Re: loading multiple tables data from single excel sheet tab

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