14 Replies Latest reply: Mar 18, 2016 3:45 AM by Peter Cammaert RSS

    Help needed - dynamic load script with a variable

    Goran Coco

      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);