2 Replies Latest reply on Nov 19, 2018 9:58 PM by MUHAMMAD MAHMOD

    combine First, Middle and Last Name

    MUHAMMAD MAHMOD

      Hi Tableau Community,

      I want to combine First, Middle and Last Name to become a full name using Calculated Field.

      Below is my sample data

      First NameMiddle nameLast name
      Johnwalkermario
      Gomezmark
      Mari

       

      i'm try using below formula

       

      But result return for John walker mario only (because Gomez and Mari dont have middle/last name)

       

       

      appreciate if you can help me.