How to convert comma separated string into multiple rows in DT

Ishu · May 11, 2020, 6:15am

Hi,

I have to convert comma separated string into multiple rows in DT. Let’s consider I have a DT like in below,

Emp_ID	Name	Email
1	Iswarya	ishu.g@gmail.com, iswarya@gmail.com, ishu@gmail.com
2	Maha	Maha@gmail.com, Maha.p@gmail.com

I want to split the Email value by using “,” and add a separate row in DT which is as shown below,

manishjagtap · May 11, 2020, 7:52am

PFA the sample workflow.
Please check if this approach works for you

Topic		Replies	Views
Comma into seprate rows Help datatable , excel , activities , string , question , data_manipulation	12	2886	December 13, 2019
Separating the string into Single quote and comma StudioX studiox , question	2	779	July 12, 2022
Extract Values from DT and store into String Studio uiautomation	4	346	October 4, 2023
Single row in dt shows as three rows Studio studio , question , activities_panel	11	542	June 15, 2023
Converting string to data table by comma as a column seperator Studio excel , question	6	1399	February 23, 2023