14 Replies Latest reply: Aug 17, 2015 11:48 AM by Sunny Talwar Branched to a new discussion. RSS

    If condition issue

    Ramana M

      Hi All,

      below is my issue highlighted in red.

      LOAD MESSAGE_CODE

           MESSAGE_DESC,

         if(Len(MESSAGE_CODE)>0, MESSAGE_DESC,MESSAGE_CODE)) as Details

      FROM $(path)MESSAGE_CODES.qvd;

       

      if the MESSAGE_CODE is exists then display MESSAGE_DESC dimension values else display MESSAGE_CODE dimension values, but it is displaying always MESSAGE_CODE dimension values in the report.

       

      Can any one suggest me.

       

      Thanks in advance.

       

      Regards,

      Ram