4 Replies Latest reply on Apr 12, 2017 10:57 PM by Michele Bongiovanni

    Concatenating 2 Fields - How do I break to next line between them?

    jenny.nedrocik

      I am trying to concatenate two text fields, but I want a line break between them.  My calculated field looks like: str([TASK_1])+' '+str([T1_HOURS])+'hr'

       

      Example of this result: Worked on request for client 1.5hr

       

      Example of what I want: Worked on request for client

                                           1.5hr

       

      I tried using a couple of sql functions that I know of, but none of them seem to work.  Does anybody know how to do this in Tableau?

       

      Thank you for your help!