Skip to Content
0
Jan 24, 2022 at 07:24 PM

List of table fields in a concatenated string

115 Views

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 :

image.png

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

Thank you in advance,

Mila Del Col

Attachments

image.png (4.5 kB)