Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ishan Singh 4Ishan Singh 4 

How can I separate the data present in single cell in Data extension?

I have two rows in data extension let us say Id and Name. The name can contain many Names but they are seperated by "," . For example:

Id      Name

1        A, B,C

So Using the query I want to acchive as below :

Id     Name

1        A

1        B 

1        C

ravi soniravi soni

hi Ishan,
we can't do it by query. but yes we achieve it by  apex  or js logic but before that I want to know  requirment.
Thank you
Siva Krishna KondapalliSiva Krishna Kondapalli
Hi Ishan Singh
https://help.salesforce.com/s/articleView?id=sf.mc_es_best_practices_data_extensions_query_activities.htm&type=5.
Please go through this link for your question, it will help you out

Mark my answer as best if you like it

Thanks 
K.Siva Krishna