3 Replies Latest reply on Feb 12, 2014 4:19 AM by Enrique Kelijman

How I concatinate several character strings in a calculated field?

Enrique Kelijman Feb 12, 2014 2:21 AM

I am new to Tableau. Tried to create a calculated field that is the concatination of a Contract Type and the year of a Contract Date.

In Excel, this would be:

Contract type	Contract Date	Contract Type-Year
T	13-May-12	T-2012

Cell C2, Contract Type-Year, will contain

=A2&"-"&YEAR(B2)

Thanks,

Enrique

1. Re: How I concatinate several character strings in a calculated field?

Aman Lamba Feb 12, 2014 3:11 AM (in response to Enrique Kelijman)

If you want the result to be T-2012 try creating a calcualted field with this formula:

Contract type + "-" + STR(YEAR([Contract Date]))

Hope it helps!
Like Show 0 Likes(0)

Actions
2. Re: How I concatinate several character strings in a calculated field?

Eric McDonald Feb 12, 2014 4:08 AM (in response to Aman Lamba)

Be careful if you ever concatenate a number first as Tableau will assume you are adding numbers. Always use the STR function as wrapper if in doubt.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: How I concatinate several character strings in a calculated field?

Enrique Kelijman Feb 12, 2014 4:19 AM (in response to Enrique Kelijman)

Thanks Aman and Eric. It works.
Like Show 0 Likes(0)

Actions

Tableau Community Forums