WHAT IS THE ERROR

[#1]

Hi all

instead of using full path i am using

but it is showing error

Cannot open file 'C:\Users\*\QVD FILES\exportPPORDHDR.qvd' The filename, directory name, or volume label syntax is incorrect.

Advanced Thank,

ramu

[Anonymous]

may be this?

\filename.qvd]

[its_anandrjs]

Why you use that and not use Relative paths

Regards

Anand

[jagan · Accepted solution]

HI,

You can use wild card characters for file name but not for file path. You have to give the file path fully.

Regards,

jagan.

[HirisH_V7]

Hi,

Try like this,

SET vIndex  = 1;

FOR EACH file in FileList('filepath\*.qvd');


IF vIndex = 1 THEN
Data:
LOAD
*
FROM $(file) (qvd);

ELSE


Concatenate(Data)
Load * ,


From $(file) (qvd);
ENDIF


LET vIndex = vIndex + 1;
Next

Hope this Helps,

Hirish

[jonathandienst]

This is not a Windows wildcard. Qlikview wildcard loads apply to filename only. If you want to open muliple files in different folders, you will have to use For Each vDir in DirList(....) and For Each vFile in FileList(...) to recurse over folders to find and load the files.

[avinashelite]

its the problem with the levels of path that you have specified ...you cannot use the wild match parameter because qlikview will be not able to identify the root folder ..try with the \.\.. or the absolute path this shoudl help you in resolving the issue. Hope this helps you 

[#8]

Hi balraj,

Its also working fine

but instead of full path i need to use wildcard

[jonathandienst]

You can't use a wildcard for your requirement. Here is some script for recursively loading all the files in a set of folders. Adapt the LOAD statement and calling path to your specific requirements

Sub Recurse(vPath, c)

  For Each vFile in FileList('$(vPath)\*.qvd')

    Data:

    LOAD *

    From [$(vfile)] (qvd);

  Next

  For Each vDirRec in DirList('$(vPath)\*')

    CALL Recurse('$(vDirRec)', c+1)

  Next

End Sub

CALL Recurse('Y:\Project1\QVDFiles', 1)