loading data

[Anonymous]

hii everyone

i  have a excel sheet  i am trying  load the data  from excel  sheet  for example assume  i have excel sheet  in sheet 1   i am having  different tables in sheet 1  .  i want  generate the  reports using those data   .  my questions  is how split the  table  from excel and load into Qlikview . can u show with small example  .. thanking  u in advance....

[Anonymous]

It is not very clear as to how the tables are separated in your excel. Are you saying you have more than one table in a single excel tab/sheet? By split the table do you mean how to load multiple tables in the single sheet into qlikview application? If that is so, one straight way to do would be to put each table in an individual excel sheet. This way qlikview can read it. Please provide the structure of your data and how you want them connected.

[Peter_Cammaert]

Please post your Excel so that we can make a useful example document with an applicable script. Any other scripts we make will be wild guesses as to what exactly you are trying to do.

[settu_periasamy]

Have a look here

How to pull data from multiple tables in a single excel sheet

[petter]

You can name your three "tables" as named ranges in Excel. Then it is possible to select them as tables in the dropdown like you would select a normal Excel sheet in the file wizard.

I have enclosed a modified Excel file where I named the three tables and also a QVW-file that shows how the load script would look like.

You define a named range by selecting for instance A2:F7 like below and then type the name of the range in the Name Box like below "Payment1" and press enter:

The load script in the attached QVW looks like this:

LOAD type, 
     card, 
     remarks, 
     benfits, 
     remarks1, 
     [paytment type]
FROM

(ooxml, embedded labels, table is Payment1);

LOAD type, 
     card, 
     remarks, 
     benfits, 
     remarks1, 
     [paytment type]
FROM

(ooxml, embedded labels, table is Payment2);

LOAD [enroll type] AS type, 
     card, 
     remarks, 
     benfits, 
     remarks1, 
     [paytment type]
FROM

(ooxml, embedded labels, table is Enroll1);