Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

Using Vsheets in loading data

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

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

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

View solution in original post

1 Reply
devarasu07
Master II
Master II

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