Combining Two String Fields

Published: 01 May 2013
Last Modified Date: 11 Oct 2022


How to create a calculated field that combines two string variables.


Tableau Desktop


Use the plus sign (+) operator to combine two string fields:
  1. Go to Analysis > Create Calculated Field.
  2. Name the calculated field and enter the following formula: 
  3. [String1] + [String2] 
  4. Click OK.

Additional Information

  • Using a plus sign (+) combines two string fields together ("abc"+ "def" = "abcdef").
  • If a space is needed between the two fields, modify the above formula "abc" + " " + "def"  = "abc def"
  • Any required punctuation (e.g. comma) may be added into the formula as needed.
  • Concatenating with a NULL value results in NULL. "abc" + NULL = NULL.

Discuss this article... Feedback Forum
Did this article resolve the issue?