Using Vsheets in loading data

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Using Vsheets in loading data

devarasu07 — Wed, 23 Aug 2017 06:07:42 GMT

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

topic Re: Using Vsheets in loading data in QlikView

Using Vsheets in loading data

Re: Using Vsheets in loading data