Any function like WM_CONCATE in webi 4.0?

[Former Member]

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 ,

Country	Projects
USA	111
USA	1222
USA	3333

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?

[nikhil_joy2 · Accepted solution]

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

[Former Member]

Thanks !!