Display multiple country names in a single cell

Hi,

For one ID’s have with multiple country, display the country in a single cell separated by semicolons.

SOME DUMMY DATA

ID NAME COUNTRY
10 KING East Honolulu
10 KING Honolulu,Oahu

20 SCOTE Honolulu
20 SCOTE Oahu

AND EXPECTED REUSLT WOULD BE in single row AS BELOW,

ID NAME COUNTRY

10 KING East Honolulu,Honolulu,Oahu
20 SCOTE Honolulu,Oahu

So request you sir please suggest me how to do this in one of webi report.

I have to show many id’s uning date parameter in the section in the repoet not single row.

Regards,
Kiran


rajenimk (BOB member since 2015-01-16)

Search and Ye will find:-

https://bobj-board.org/t/170527


Mak 1 :uk: (BOB member since 2005-01-06)

This worked fine in BOXI 3.1 but in 4.1 it is having problems. I suspect that something has changed in the calculation engine that is changing the behavior of these variables. I haven’t been able to find a work around yet.


torybennetsen :us: (BOB member since 2013-05-07)

Must be your variable set up, as at least one of those methods from that post, or the ones linked to, was proven to work in 4.1, see above.


Mak 1 :uk: (BOB member since 2005-01-06)