cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

can try with

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