Two tables in One excel sheet

[#1]

Hi

      In single Excel sheet i have two tables how to load that data into Qlikview

Regards,

Singam.

[amit_saini]

Amar,

Step1:

First open the file “Daily Operational Report_28 02 2011 ” delete sheets where no data required for reports.

Step2:

Then press Alt F11, double click on any sheets in the left of the opened window and copy the below code as shown in the below picture.

Sub renameSheets()
Dim iSheetCount
For iSheetCount = 1 To Sheets.Count
Sheets(iSheetCount).Name = iSheetCount
Next iSheetCount
End Sub

Step3:

Then run by clicking the run button like below

Step4:

Save as the file in xlsx fomat.

Step5:

Then Open the QVW, Press Cntrl E, go. Assuming the file contain 290 sheets.
Eg. for loop=1 to 290 

Step6:

Reload QVW

Hope this will help you.

Thanks,

AS

[#3]

Hi Amit

           I need all sheets data for reporting

Regards,

Singam,

[#4]

Hi,

If you have two separate tables like sales and budget then load separatly like this

Sales:

Load *

           from (excel path,table name is Sales);

Budget:

Load *

           from (excel path,table name is Budget);

if you have sheet1,sheet2 like this you have two table with same field names using for loop load the data at a time like

for i=1 to 2;

Load * from (excelpath, Sheet($i));

Next;

In single sheet you have two tables then using the Enable Transformation Step you can load the data into qlikview.

Just play with that property you will get the required output

[#5]

Hi Rakesh

       The two tables in one sheet only it is not in different sheets and it is not loading properly please find the attachment in the above conversion