Eclipse Community Forums: BIRT » Split Value into rows

Help

Home

Home » Archived » BIRT » Split Value into rows(How to split Value into Rows )

Show: Today's Messages :: Show Polls :: Message Navigator

Split Value into rows [message #1807456]

Thu, 30 May 2019 13:47

hatra atrin

Messages: 20
Registered: February 2014

Junior Member

Hi All,
I have an urgent requirement that I need to split value from column "Level" ( image1) into multiple rows (image2),
assuming we dont know what is the number of values separated by comma ( ie : it could be 1 to 100 maybe ).
I have attached two images, image 1 is what my data look like and Image2 is what it should look like.
Thanks

Attachment: Image1.png
(Size: 7.78KB, Downloaded 82 times)
Attachment: Image2.png
(Size: 11.60KB, Downloaded 85 times)