topic load over loop concatenating in QlikView

load over loop concatenating

mohamed_ahid — Wed, 23 Sep 2015 12:03:19 GMT

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;

The script generate one qvd and with no name .

any suggestion please .

Thx

Gysbert_Wassenaar — Wed, 23 Sep 2015 12:57:25 GMT

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 — Wed, 23 Sep 2015 13:02:13 GMT

LOL!

Thx