Avatar

Correct answer by
Community Advisor

Hi,

 

You can use Query activity and Enrichment in a workflow to change your data set and get result in above format. Try below steps

 

A) As an example I have created a schema name as cus:pivot

kapilKochar_0-1652796515828.png

 

B) Create a workflow like below 

i) Query activity

kapilKochar_1-1652796588624.png

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

kapilKochar_2-1652796639611.png

 

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. In below example since I have two values so I have selected two

kapilKochar_3-1652796708206.png

 

Add your data from these different temp enrichment table and result will be like below

kapilKochar_4-1652796793609.png

 

Hope this helps. 

 

 

View solution in original post