2 Replies Latest reply: Jul 16, 2014 5:56 AM by Ha D. RSS

    Append two translated values to one listbox

      Hi all,

       

      I have two translated texts that (index 1, 2, in an Excel table) I would like to add into one listbox

       

      The texts are obtained by those formular

      = Only({< Index={1}>} upper( [$(=vDataLanguage)])) ---- TEXT 1

      = Only({< Index={2}>} upper( [$(=vDataLanguage)])) ---- TEXT 2

       

      Which expression should I create to have both values displayed in the same list box

       

      (Listbox)

      TEXT1

      TEXT2

       

      Thank you

        • Re: Append two translated values to one listbox
          Martin Mahler

          You should append (concatenate) them in the script or at least create a Data Island consisting of the translated texts.

            • Re: Append two translated values to one listbox

              I know it is feasible via script but I'd like to know if we can do it at design using expression.

               

              I have the following table. Column "Detail per day" is displayed in the interface. Is there a way to obtain the corresponding _choiceID when a value is selected in "Detail per day" ?

               

              I heard about mapping table, but does it allow 3 columns instead of 2 as typical example ?

               

              LOAD * INLINE [
                  _Language, "Detail per day", _choiceID
                  Français, oui, 'Y'
                  Français, non, 'N'
                  Deutsch, ja, 'Y'
                  Deutsch, nein, 'N'
                  English, yes, 'Y'
                  English, no, 'N'
              ]
              ;