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

       

      TRIM

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

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

       

      But my o/p is not as expected.

       

      Please help me in this case.

      Thanks

      Chandra