Help needed - dynamic load script with a variable

[meyham2001]

Dear community I need help.

I'm trying to automate process of loading the newest xlsx file in qvw and i wrote a script that should do just that.

I'm stuck at the point where I need to transfer value stored in variable to the path of loaded xlsx. I've tried everything. Using LET, SET...

Plesae help me because I'm stuck here...

Code:

SET vMaxDate = MAX(Mid(FN.Filename,Len(FN.Filename)-11,8));

//Load Phonebook entries

AC_temp:

LOAD

     Lower(Email)                AS %email,

     DN,

     PersonnelID,

     FullName,

     FamilyName,

     ChristianName,

     Country,

     OU,

     OUName,

     PhoneNumber,

     MobileNumber,

     Company,

     Position,

     DivisionID,

     DivisionName,

     All_OUs,

     OU_Count

FROM

C:\Users\mydocuments\Qlik_Training\BL_obsolete\DEV\B_L_obsolete\0150_RawData\CSV\Phonebook.$(vMaxDate).csv

(txt, codepage is 1250, embedded labels, delimiter is ';', msq);​

[Peter_Cammaert]

If your question has been answered to satisfaction, please close the discussion by marking an answer as Correct. That answer will appear in the same frame as your original post at the top, making it easier for other Community Members to find Question & Answer. Thanks.

Peter

[rubenmarin]

And marking the correct answer also helps others to not waste time reading an already solved thread.

[meyham2001]

Thank you Peter once more.

[Peter_Cammaert]

My pleasure.

Enjoy QlikView and the Qlik Community.