Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    can try with

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

    Add comment
    10|10000 characters needed characters exceeded