Skip to Content
0

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

Jul 09, 2017 at 06:59 PM

115

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Christian Kalweit Jul 16, 2017 at 06:54 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0
0