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 cr...

Hi, Just posting here so anybody can use it. 12345/1000 = 12.34 not 12.35 Code: 12.34 Floor(ToDouble(@CONTENT4)/1000)+'.'+Substring( Iif(Length(ToString(Mod(ToDouble(@CONTENT4), 1000)))<=1,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'00' ),Iif(Length(ToString(Mod(ToDouble(@CONTENT4), 1000)))=2,LPad(ToString(Mod(ToDouble(@CONTENT4), 1000)),3 ,'0' ),ToString(Mod(ToDouble(@CONTENT4), 1000)))),1,2 ) Code: 12.35 Round(ToDouble(12345)/1000,2) Regards,Anil