3 Replies Latest reply on Dec 13, 2017 12:19 AM by Chandra Sekhar Guntamukkala

    Combining two columns data to apply for filter logic

    Chandra Sekhar Guntamukkala

      Hi I have two columns Event and Event 1 for each of the record.



      Event column has Forward, Resend and Send and NULL options for each record and similarly Even 1 column has Download and Null options.


      I need to create a new column with the values as Download, Forward, Resend, Send and Null options.


      I have tried the below solution



      (IFNULL(STR([Event])," ")+" "

      + IFNULL(STR([Event (Extract3)])," "))


      But my o/p is not as expected.


      Please help me in this case.