Concatenation of multiple values

system · October 8, 2018, 3:33pm

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

rajx72 (BOB member since 2006-08-02)

system · October 8, 2018, 7:20pm

There’s a solution here:

mikeil (BOB member since 2015-02-18)

system · October 8, 2018, 8:39pm

Hi Raj,

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

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

system · October 8, 2018, 9:39pm

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

rajx72 (BOB member since 2006-08-02)

system · October 9, 2018, 2:28pm

Does the blog post below help?

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

jemstar (BOB member since 2006-03-30)

Lome · June 21, 2021, 1:00pm

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

Thank