Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In single Excel sheet i have two tables how to load that data into Qlikview
Regards,
Singam.
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
Amar,
Please share you excel sheet.
Thanks,
AS
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.
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
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
Hi Amit
Please find the attachment
regards,
Singam.
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..
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
Hi Amit
Could you please brief about it to which excel sheet i have to do
what i you said i din't understand