4 Replies Latest reply on Aug 27, 2016 1:09 PM by Chrissy Scott

Convert sys id list into name list?

Chrissy Scott Aug 24, 2016 6:22 PM

Hi All,

So I have a field that lists Sys ID values, separated by columns. Like this:

Each of those Sys IDs represents a line of business (LOB). Like this:

Global Shareholder Services	ca71e63813af52009e0ad7b2e144b03c
High Net Worth	d371e63813af52009e0ad7b2e144b071
Human Resources	d271e63813af52009e0ad7b2e144b048

How do I create a calculated field that will allow me to represent the listed LOBs? So in the first image, how do I get line three to read "Global Shareholder Services, Investment Management" ? The contains function gets me started, but... Do I have to list every possible combination (there are 21 individual items in this list)?

1. Re: Convert sys id list into name list?

Tom W Aug 24, 2016 6:33 PM (in response to Chrissy Scott)

I would do it like this;
TRIM(mid(
if CONTAINS([Lineofbusiness],"A") then ",A" else "" end +
if CONTAINS([Lineofbusiness],"B") then ",B" else "" end +
,2,1000))

The MID function ensures you remove the leading trail off the first comma which is returned by the field.
Like Show 0 Likes(0)

Actions
2. Re: Convert sys id list into name list?

Chrissy Scott Aug 24, 2016 6:46 PM (in response to Tom W)

Like this? Why am I getting the syntax error?
Like Show 0 Likes(0)

Actions
3. Re: Convert sys id list into name list?

Tom W Aug 24, 2016 6:57 PM (in response to Chrissy Scott)

Place your mouse over the squiggly line to see why you're getting an error. I can tell from looking at it, you've got another plus symbol at the end of line three but you're not "adding" it to anything after that symbol.

Make sure you have a comma in front of your global shareholder services in the second line too.
Like Show 0 Likes(0)

Actions
4. Re: Convert sys id list into name list?

Chrissy Scott Aug 27, 2016 1:09 PM (in response to Tom W)

Thanks!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Convert sys id list into name list?

1. Re: Convert sys id list into name list?

2. Re: Convert sys id list into name list?

3. Re: Convert sys id list into name list?

4. Re: Convert sys id list into name list?

Actions

More Like This