show row attribute data with delimiter in single column

[Former Member]

Hi All,

Currently,our system has projects and person tagged to it datas.

one Person is working in multiple projects. in that case, there will be multiple records for each person.

I wanted to show all his/her projects in a single column .

For eg.,

Ramnath - A,B,C

Vikas - C,D,E

Manoj - P,Q,R

Is it achievable in graphical calculation view or any other option to achive ?

Please share your thoughts

Thanks

V.Ramnath

[lbreddemann]

You're looking for the STRING_AGG function here. Check out the documentation and the discussions about it here on SCN to get an idea on how to use it.

And no, this is not available in the graphical modelling.

- Lars