List of table fields in a concatenated string

[former_member787006]

Hi everyone, I'm new in BO Web Intelligence and now I'm working with SAP BusinessObject BI 4.2.

I have a question: there is a way to transform the fields of a table into a single string with all values separated by a separator like ";"?

For example, I have this query :

"select COD_BRANCH, DESC_BRANCH from LIST_OF_BRANCHES"

which returns :

I need a string variable "branches" in the BO report which returns: A;B;C

Thank you in advance,

Mila Del Col

[jerryjanda]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members. Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide, the more likely it is that members will be able to respond.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Kind regards,

--Jerry

Moderation Lead

[mhmohammed · Accepted solution]

Hi Mila,

Try the below blog, I've used this workaround at multiple clients, works perfect.

https://irfansworld.wordpress.com/2011/02/18/how-to-display-a-database-column-values-in-a-single-cel...

Thanks,
M Mohammed

[former_member787006 · Accepted solution]

Hi Mohammed,

thank you very much for your help!

Is there any other solution using string or other functions directly in the report, like concat([COD_BRANCH];";")?

M Del Col

[mhmohammed]

Try the below link to create the workaround it in the report directly, but I’ve seen it fail when there is too much data.
https://blogs.sap.com/2015/08/15/string-aggregation-on-webi-report-level/

Thanks!