Apptio for All

 View Only

 Concatenating data related rows

Jump to  Best Answer
  • ApptioforAll
Apptio Community Member's profile image
Apptio Community Member posted 08/31/22 02:44 PM
Hi everyone!

I had an article bookmarked which came handy sooo many times, but when I go to the link now the page is blank. Does anyone know where I can find this article again?

Concatenating Related Data Rows | Apptio Q&A Forum


It helps give the steps on how to concatenate the rows with the same ID
So for example:

App ID     Owner
1                 Rachel
1                 Joe
1                 Dan

would result in

1     Rachel;Joe;Dan


TY!!
#ApptioforAll
Apptio Community Member's profile image
Apptio Community Member posted 08/31/22 02:52 PM  Best Answer
I believe you are interested in the Unique Values Function.

UniqueValues function (apptio.com)

Note, you can't use this in the same table that the data resides.  I'm not sure of the article you mention, but I'm guessing it's using this function.
#ApptioforAll
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 09/01/22 06:33 AM
Maybe @Debbie Hagen can work her magic here...​
#ApptioforAll
Debbie Hagen's profile image
Debbie Hagen posted 09/01/22 12:14 PM

Hi @rachel yaghoubzadeh,
That article still appears live for me.  What kind of error are you getting when you click on that link?  Can you share a screenshot?

Cheers,

Deb

​


#ApptioforAll
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 09/02/22 02:02 AM

It doesn't throw an error, @Debbie Hagen, but the page appears empty, both in Chrome & Edge:

​


#ApptioforAll
Apptio Community Member's profile image
Apptio Community Member posted 09/02/22 09:24 AM
@Debbie Hagen I got the same result as Guillermo when I clicked the link. I tried searching for that phrase and Rachel's post is the only thing that turns up in search
​

Maybe it's been marked as Apptio employee only somehow?
#ApptioforAll
Debbie Hagen's profile image
Debbie Hagen posted 09/02/22 10:07 AM
Interesting.  I can see it and it doesn't appear to be archived.  Let me do some investigating on my end.
#ApptioforAll

Related Content