topic WHAT IS THE ERROR in QlikView

WHAT IS THE ERROR

Thu, 04 Feb 2016 07:27:28 GMT

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

Re: WHAT IS THE ERROR

Anonymous — Thu, 04 Feb 2016 07:34:54 GMT

may be this?

\filename.qvd]

Re: WHAT IS THE ERROR

its_anandrjs — Thu, 04 Feb 2016 07:36:51 GMT

Why you use that and not use Relative paths

Regards

Anand

Re: WHAT IS THE ERROR

jagan — Thu, 04 Feb 2016 07:49:08 GMT

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.

Re: WHAT IS THE ERROR

HirisH_V7 — Thu, 04 Feb 2016 07:58:10 GMT

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

Re: WHAT IS THE ERROR

jonathandienst — Thu, 04 Feb 2016 08:02:11 GMT

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.

Re: WHAT IS THE ERROR

avinashelite — Thu, 04 Feb 2016 08:03:49 GMT

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

Re: WHAT IS THE ERROR

Thu, 04 Feb 2016 08:25:33 GMT

Hi balraj,

Its also working fine

but instead of full path i need to use wildcard

Re: WHAT IS THE ERROR

jonathandienst — Thu, 04 Feb 2016 08:41:55 GMT

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)