Need to convert rows data to columns using with recursive

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
N/A

Need to convert rows data to columns using with recursive

Hi team,

Can you please help me to get the WITH RECURSIVE query to divide the data from rows to columns(I think there is a strtok_split function, but need it using WITH RECURSIVE)

 

attached image is the sample data recursive.JPG

1 REPLY
N/A

Re: Need to convert rows data to columns using with recursive

Why recursion, which is  more expensive compared to STRTOK_SPLIT_TO_TABLE?