Skip to Content
0

Converting single cell (comma separated list) into rows in WEBI is possible...??

Nov 23, 2017 at 07:12 AM

103

avatar image
Former Member

Hi,
Is thare any way to convert values of single cell separated by comma in multiple Rows in Webi 4.1..

For example:-


Comp Ename
abc Dev,Divyesh,Ramesh,Anadi


to


Comp Ename
abc Dev
abc Divyesh
abc Ramesh
abc Anadi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 07, 2017 at 07:55 PM
0

can try with

Length(userresponse())-length(replace(userresponse();";";""))

Share
10 |10000 characters needed characters left characters exceeded