How to combine two different rows into a one Single row in HANA Calculation View.

[former_member462348]

Hi Experts

I have a requirement as below, Kindly help me to fix this.

Normal Output
Partner Role

SAP A
SAP B
SAP C

Expected Output

Partner 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

[former_member247222]

You could implement it as a table function and use HANA SQL function STRING_AGG.

[former_member462348]

Hi Christian

Can you please provide some sample code, so that it will be more useful to do the same for my requirment.

Thanks
Rufus Samuel

[former_member247222]

There's an example at SAP Help:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/a924ee1e98ab435a874efa32e6...