8 Replies Latest reply: Jul 23, 2013 6:23 AM by David Ambrozie RSS

    Find value in the column and derive the result

      I have a table , which contains the following data.

       

       

      tcodeLicenseTypeID
      CJ20N1
      CJ20N2
      ME2N1
      ME2N2
      ME23N1
      ME23N2
      ME51N1
      ME51N2

       

       

      I want an expresssion, which will lookup for each unique tcode , if the licensetypeid '2' is available for that tocde and return text "All available in type 2'