Avatar

Level 1

Hi,

You can use enrichment activity to do the transpose of data(rows to column). Please follow below steps.

Step1: Take the enrichment activity and make the self join with same table with the help of 1: N join while giving join condition.

Step2: While adding the data please make sure to add column(No. of records to retrieve as per your convenience (By default it will be max 3 rows) ). So it will create multiple enrichment table based on your records to retrieve. If you have chosen 3 then it will create 3 different temp enrichment table. 

Step3: Take final enrichment activity and then add your data from these different temp enrichment table.

 

Anilr1717_0-1626442516692.png

 

Thanks,

Anil