Other root reference in filelist than in root folder in QMC.

mwanders — Mon, 26 Jan 2026 18:19:17 GMT

Hi people,

For a client a have to manage a QlikView document which I did not create. My client is going to move a location where files are stored. My task is to change the location reference in the QlikView script. No problem.

Script:

Sub Dodir(Root)
for each Ext in '*.*'
for each File in filelist (Root & '\*.' & '$(Ext)')

ListOfFiles_Temp:
Load
Left(Mid('$(File)', index('$(File)','\', -2)+1), index(Mid('$(File)', index('$(File)','\', -2)+1), '\', 1)-1) as Folder,
'$(File)' as FullName
autogenerate 1

The outcome for field "FullName" is: \\sdc-filer-01\hgd$\Docs\PDF documenten\Verkoopfacturen\ and field "Folder" is "Verzonden".

The script generates a list with filenames. Ok, I understand that.

The filelist is created with Root and after a search this must be a root folder. If I look in the QMC then I see a different folder than \\sdc-filer-01\hgd$\Docs\PDF documenten\Verkoopfacturen\ . It's has a reference to D:\\QlikView.

How do I change Root that has it's reference to \\sdc-filer-01\hgd$\Docs\PDF documenten\Verkoopfacturen\?

I searched but I can not find such thing. Can somebody help me?

Kind regards,

Martijn Wanders

Re: Other root reference in filelist than in root folder in QMC.

Bill_Britt — Thu, 06 Jun 2019 17:34:14 GMT

Hi,

You should have a variable set for the rootPath. See below.

rootPath = 'D:\Router';

Bill

Re: Other root reference in filelist than in root folder in QMC.

mwanders — Fri, 07 Jun 2019 08:16:36 GMT

Thank you for your reply! In the mean time I found a solution in another thread.

Re: Other root reference in filelist than in root folder in QMC.

Bill_Britt — Fri, 07 Jun 2019 12:43:53 GMT

Hi,

Please mark the issue as solved.

Thanks

Bill

topic Re: Other root reference in filelist than in root folder in QMC. in QlikView

Other root reference in filelist than in root folder in QMC.

Re: Other root reference in filelist than in root folder in QMC.

Re: Other root reference in filelist than in root folder in QMC.

Re: Other root reference in filelist than in root folder in QMC.