concatenate value of multiple rows in new column

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.
Highlighted
Visitor

concatenate value of multiple rows in new column

Hi All,

 

I have the below data set. I tried using With Recursive functionality of teradata but not able to achive expected result.

 

ITEM_IDHDR_SKU
40,5701
6,481,2551
7,067,8511
235,2202
7,067,853

2

 

Expected output -

ITEM_IDHDR_SKU
40,57040570/6481255/7067851
6,481,25540570/6481255/7067851
7,067,85140570/6481255/7067851
235,220235220/7067853
7,067,853235220/7067853

 

 

Thnaks in advance.

Bharat