Hi Experts
I have a requirement as below, Kindly help me to fix this.
Normal OutputPartner Role
SAP ASAP BSAP C
Expected OutputPartner Role
SAP A,B,C
Here SAP has three different rows in database, But in calculation view I need to display them as a one single row in HANA.
Can some one help me to achieve this ??
Thanks
Rufus Samuel
You could implement it as a table function and use HANA SQL function STRING_AGG.
You already have an active moderator alert for this content.
There's an example at SAP Help:
https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/a924ee1e98ab435a874efa32e6f0ae14.html
Add comment