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.
Solved! Go to 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
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
Thanks a lot Dnoeth.
It really helped to transform the comma seperated values to column values as per requirement.