11 Replies Latest reply: Dec 7, 2015 8:03 AM by Peter Cammaert RSS

    Evaluate variable in script

    Robert Mika

      I'm trying to look at a table from variable

       

      My set-up

       

      Languages:

      Load * Inline [

      Language

      EN,

      AL,

      ]

      ;

       

      Tansalation:

       

       

      LOAD

          ID,

          EN,

          AL

       

      FROM

      [..\Config\For Translation.xls]

      (biff, embedded labels, table is UniqueObjectID$);

       

      My Expressions in GUI are

       

      vLanguage:

       

      =chr(39)& Language& chr(39)

       

      then for each field:

       

      =fieldvalue($(vLanguage),25)

       

      Which is looking at the table with translation and picking up the right field.

       

       

      So I will wrap this

       

      LET vHITS:fieldvalue($(vLanguage),25)

       

      so the evaluation will take place at script level?

       

       

      I'm trying few option but  none is working.

       

      The aim is to have all fields replace with variables from external sources