files name extracting

[souadouert]

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

[MK_QSL]

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

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

          files:

          LOAD *,

           FileName() as filename

          FROM [$(File)];

Next

[lironbaram]

hi

if this is all your script

you miss a "next"

in the end of the script

[souadouert · Accepted solution]

hello liron

i tried this script

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

Load

     FileName() as Filepath

From $(sPathResources);

and it s working