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?


      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



      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!