Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Farther down in your script, there should be a Call DoDir command.
The parameter is the value for Root. so Call DoDir(What ever path you want to set)
Glad to help.
If any of the replies solved your problem, please mark as Correct.