Transform comma seperated row values to column

[Sourabh_17]

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.

[dnoeth · Accepted solution]

Have a look at the STRTOK_SPLIT_TO_TABLE function, see https://community.teradata.com/t5/General/Value-parsing-in-Teradata/m-p/56060/highlight/true#M3535

[Sourabh_17]

Thanks a lot Dnoeth.

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