load over loop concatenating

[mohamed_ahid]

HI all ,

i'm trying to load a several qvd file and for every one generate a qvd with distinct value .

here bellow my script

FOR Each Temp_File  in Filelist ('D:\Users\u142329\Desktop\test\PRLVMT_RUN_*.qvd')

   temp:

  LOAD Distinct

  EndToEndId,

  Numero_Facture,

  PMT_REQ_SENT_COUNTER,

  FileName() as FileName

  From

  $(Temp_File)(qvd);

  LET FileName = PEEK('Filename');

   STORE temp into D:\Users\u142329\Desktop\test_mahid\$(FileName).qvd (qvd);

   drop table temp;

NEXT

The script generate one qvd and with no name .

any suggestion please .

Thx

[Gysbert_Wassenaar · Accepted solution]

LET FileName = PEEK('Filename');

Qlikview is case sensitive and that means FileName is not the same as Filename. Try

  LET FileName = PEEK('FileName');

[mohamed_ahid]

LOL!

Thx