7 Replies Latest reply: May 4, 2016 5:52 AM by florentina dogaru RSS

    Eliminate Null value

    Mark Graham

      Hi all,

       

      I'm trying to eliminate the null value if the filed has value in it.

       

      Eg:

      If ID has Code values null and XK

      Then i want to eliminate null and display only XK so as to avoid one extra line which is duplicating the records

      Please see the attachment.