topic loading multiple xcel files from multiple folders in QlikView

loading multiple xcel files from multiple folders

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

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

Re: loading multiple xcel files from multiple folders

vijetas42 — Fri, 09 Mar 2018 07:11:04 GMT

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

Re: loading multiple xcel files from multiple folders

jonathandienst — Fri, 09 Mar 2018 07:33:31 GMT

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

Re: loading multiple xcel files from multiple folders

Stars — Sun, 10 Nov 2019 20:53:26 GMT

Did you figure this out? I can't. I want to do exactly what you're describing.