Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Any function like WM_CONCATE in webi 4.0?

Hi ,

I am trying to have different values coming from the same column in DB , to accumulate in one cell and also wanna concatenate it

For Example ,

CountryProjects
USA111
USA1222
USA3333

want to show the above as in one cell

USA          111,1222,3333

I know it can be done at DB level by WM_CONCATE but how to do it in Webi 4.0?

Former Member
replied

Hello Usman,

PFB a useful link where a similar requirement has been explained well.

http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html

Hope it helps

Regards,

Nikhil Joy

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question