Transform comma seperated row values to column

Analytics
Highlighted
Teradata Employee

Transform comma seperated row values to column

Hello,

 

I have a table with below two columns with their comma seperated row values.

SID                     Vol_Str

----------------------------------------------------------

ID1                  abc,def,ghi,jkl

ID2                  mno,pqr,stv,wxy

 

I want to transform the comma seperated values of Vol_Str to column values as given below

 

SID                     Vol_Str

-------------------------------------------------

ID1                      abc

ID1                       def

ID1                       ghi

ID1                       jkl

ID2                        mno

ID2                      pqr

ID2                       stv

ID2                      wxy

 

Is there any function in teradata which could be used to achive this transformation

Thank you for help.


Accepted Solutions
Junior Contributor

Re: Transform comma seperated row values to column

1 ACCEPTED SOLUTION
2 REPLIES
Junior Contributor

Re: Transform comma seperated row values to column

Teradata Employee

Re: Transform comma seperated row values to column

Thanks a lot Dnoeth.Smiley Happy

It really helped to transform the comma seperated values to column values as per requirement.