- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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.
Thanks,
Anil
Views
Replies
0 Likes
Total Likes