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.

[vardhancse]

If it was in single excel sheet and multiple workbooks, after selecting the excel sheet we can select the workbook.

In that way if load multiple tables from single excel sheet and multiple work books

[amit_saini]

Amar,

Please share you excel sheet.

Thanks,

AS

[#4]

Hi Sasi

        I have data in one workbook multiple excel sheet but in one excel sheet i have two tables .I loaded that data the data is showing  only in table viewer when we click on preview. But the field names are not showing in script level.

Regards,

Singam.

[danieloberbilli]

If you use the File Wizard, you just click on the X-icons of the columns that you don't want to load:

So 1st: you only load the columns of table 1 and then afterwards you open the wizard again and load  the columns of table 2

[its_anandrjs]

Hi,

You can get the help of the transformation steps option available in the file wizard when you load the excel sheet

and then click on the button Enable transformation step and then you can find many options.

Regards

Anand

[#7]

Hi Amit

            Please find the attachment

regards,

Singam.

[SergeyMak]

Hi,

When you load data from the sheet with two tables press next and Enable Transformation step.

Then delete what you don't need.

Next time do otherwise..

[amit_saini]

Try this:

Step1:

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

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

Step 2: Then run by clicking the run button like below

Step3:

Save as the file in xlsx fomat.

Step4 :

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

Step5:

Reload QVW

Thanks,

AS

[#10]

Hi Amit

          Could you please brief about it to which excel sheet i have to do

         what i you said  i din't understand