topic Fetch Data from Sub Folder in QlikView

Fetch Data from Sub Folder

sona_sa — Wed, 17 Aug 2022 12:57:26 GMT

Hi Team I have folder structure like :

C:\Users\AM20173015\Documents\MAS CLAIM\Apr\Amit1.Xls

C:\Users\AM20173015\Documents\MAS CLAIM\May\Amit1.Xls

C:\Users\AM20173015\Documents\MAS CLAIM\June\Amit1.Xls

Now I want to fetch data data from xls. Format is same only month difference is there.

Re: Fetch Data from Sub Folder

Or — Wed, 17 Aug 2022 13:15:24 GMT

I'd suggest trying one of the links mentioned in this thread. If that doesn't apply to your situation, I'd suggest specifying what the issue is for more details.

https://community.qlik.com/t5/QlikView-App-Dev/loop-all-files-from-a-folder-and-its-sub-folders-and-add-new/td-p/1286783

Re: Fetch Data from Sub Folder

MarcoWedel — Wed, 17 Aug 2022 16:22:58 GMT

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptControlStatements/For%20Each.htm#:~:text=Example%202%3A,call%20DoDir%20(%27C%3A%27)