Concatenation of multiple values

Hi

We are using BOBJ 4.2 with Hana as backend. I have getting multivalue error because i have multiple rows for on combination of Order no and lineno. User wants, if there are multiple values I should concatenate it otherwise show as it is. Enclosing a sample data .

Please advise.

Thanks
Capture.JPG


rajx72 (BOB member since 2006-08-02)

There’s a solution here:


mikeil (BOB member since 2015-02-18)

Hi Raj,

Try this, if you want to create this in the Universe


M H Mohammed :us: (BOB member since 2010-06-16)

Thanks. No we don’t use universe. Everything is on the report.


rajx72 (BOB member since 2006-08-02)

Does the blog post below help?

http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html


jemstar :ireland: (BOB member since 2006-03-30)

Hi, can you explain the solution? the link does not work

Thank