topic files name extracting in QlikView

files name extracting

souadouert — Thu, 20 Apr 2017 09:30:40 GMT

Hello ,

i want to extract all name files , i use this script

Set sPathResources = 'C:\pfe\qlikview\qvd\DONNEES_RECAPFEV2016';

for each File in FileList('$(sPathResources)\*.qvd')

files:

LOAD *,

FileName() as filename

FROM [$(File)];

when i execute this script , i have only the first name files in folder

Re: files name extracting

MK_QSL — Thu, 20 Apr 2017 09:33:41 GMT

Set sPathResources = 'C:\pfe\qlikview\qvd\DONNEES_RECAPFEV2016';

for each File in FileList('$(sPathResources)\*.qvd')

files:

LOAD *,

FileName() as filename

FROM [$(File)];

Next

Re: files name extracting

lironbaram — Thu, 20 Apr 2017 09:34:12 GMT

hi

if this is all your script

you miss a "next"

in the end of the script

Re: files name extracting

souadouert — Thu, 20 Apr 2017 10:06:04 GMT

hello liron

i tried this script

Set sPathResources = 'C:\pfe\qlikview\qvd\DONNEES_RECAPFEV2016\*';

Load

FileName() as Filepath

From $(sPathResources);

and it s working