Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all , i have 3 folders jandata,febdata,march data
in each folder i have -6 excel sheets loaded . i want all the folders data to keep in one qvd(extarctor).
i am giving some sample data. can anyone please help , how to load
under january folder i have excels like this
for week2 i have excel like this
for week1 i have excel like this
under febraury folder i have data like this
for week5.2 i have excel name like this
Can anyone please tell how to load all excel files under diffrent folders in same sinlgle qvd
Please refer this thread it may help you.https://community.qlikview.com/thread/247144
or when you are trying to load excel one by one from same folder and your files having same sarting name then, e.g. you can directly write in from like,(excel folder path)..\Week*.xlsx
And these
Loading multiple excel sheets containing different data in one go using for loop
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
Re: Multiple excel sheets(Dynamic) load in qliksense
Did you figure this out? I can't. I want to do exactly what you're describing.