Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When we load data, we could use V sheet option to do that.Can anybody explain why this is used & the pros of this. Can this be used in loading data in cross table structure as well? Appreciate if v sheet data loading is clearly shown with a data loading sample to see where all necessary applications such as comas,inclusions of certain terms at which places & so on!
Thanks
Neville
Hi,
V Sheet? are you taking about loading multiple excel sheet using for loop. if so it's used
NEXT vSheet which means looping (this variable will contain file path and file name for each loop) and it's used to
load more than one excel file/sheets with the name of the sheet and data.
Loading particular excel sheets into Qlikview
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
Hope this helps to you.
Thanks,Deva
Hi,
V Sheet? are you taking about loading multiple excel sheet using for loop. if so it's used
NEXT vSheet which means looping (this variable will contain file path and file name for each loop) and it's used to
load more than one excel file/sheets with the name of the sheet and data.
Loading particular excel sheets into Qlikview
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
Hope this helps to you.
Thanks,Deva