1 Reply Latest reply: Apr 29, 2016 4:48 PM by Phaneendra Kunche RSS

    Add dynamic suffix to column names in load script

    Jean-Marc Nihoul

      Hello,

       

      I am trying to set up a multilingual environment (dutch - french). In my database I always have 2 columns for a caption or a name. One is suffixed with _NL, the other with _FR. Instead of selcting both columns I would like to select only one depending on a language variable.

       

      LOAD "CAMPUS_ID",

          "CAMPUS_NR",,

          "CAMPUS_NAME_NL",

          "CAMPUS_NAME_FR";

      SQL SELECT "CAMPUS_ID",

          "CAMPUS_NR",

          "CAMPUS_NAME_NL",

          "CAMPUS_NAME_FR"

      FROM dbo."REF_CAMPUS_V";

       

      Can someone help me out here? !