By: Eric Parker
Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can also sign up for a Tableau Office Hour to work with him directly!
So you want to concatenate multiple text values in Tableau, huh? Great!
In some ways, this process is easier in Tableau than Excel or other data-related tools. Whether you are concatenating string fields, static text, or even text-based parameters, all you need to do is add a plus sign between your values!
Where this can get tricky is when you are concatenating string values with numeric values. Tableau will get confused by adding string and numeric values together. In that scenario you will need to utilize a type conversion function (STR) to convert numbers to text so Tableau knows you are not looking for a numeric output.
Check out this video for a walkthrough on concatenating a string field, numeric field and static text together into a single text output!
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss out on new blog posts, videos and events!