variable update issue

patrou38 — Fri, 14 Apr 2017 08:35:31 GMT

hello,

in the script below I capture the name of the file which is put in the field 'NomDeFichier' <== this works fine

after I tried to put the part 'W201712' in the variable 'vNameQvd' with out success. the function SubField(NomDeFichier,'_',7) work properly.

My ONLY problem after a lot of trials I cannot put the result of my function Subfield 😞 maybe it's a syntax issue ?

Please I need help !!!!

Load Distinct ToCheck, filebasename( ) as NomDeFichier
from ;
LET vNameQvd = SubField(NomDeFichier,'_',7); // <== doesn't work !!!!
store BO into BOvsEDA_$(vNameQvd).qvd (qvd);

thank you in advance

Patrick

Re: variable update issue

Aurelien_Martinez — Fri, 14 Apr 2017 08:40:09 GMT

Hi,

LET vNameQvd = SubField(Peek('NomDeFichier', 0), '_', 7);

Re: variable update issue

patrou38 — Fri, 14 Apr 2017 09:11:31 GMT

Thank you very munch

topic Re: variable update issue in QlikView

variable update issue

Re: variable update issue

Re: variable update issue