Split the data rows set into multiple rows

[gjs_shankar]

Hi Team,

Based on the comment column, I need to split the multiple rows from the CV . How we can achieve in HANA..?

Thanks in Advance

[Abhishek_Hazra]

Hi gjs_shankar,

Have you gone through this blog post : https://blogs.sap.com/2019/02/10/split-string-into-multiple-rows-using-sql-in-sap-hana/? If you replace the comma with semi-colon, it exactly fits into what you asked for.

Best Regards,
Abhi