merge column values into a comma separated list

building reports webintelligence
1

Hello, I am wondering if there is a way in Webi to do the following:

I have a data set of the form:
Account Group Division
A1 G1 NA
A1 G2 SA
A1 G3 NA
A2 G2 SA
A3 G3 NA

I would like the Webi report to display it as
Account Group Division
A1 G1, G2, G3 NA, SA
A2 G2 SA
A3 G3 NA

Basically, I need a way to merge the column info from multiple records into one comma separated list based on a pivot column (in this case Account).

I am a novice to WebI and I am not sure if WebI can address this. Can someone please share some knowledge and enlighten.

Thank you,
Ashish

ashishg (BOB member since 2011-02-01)

2

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

Marfi :poland: (BOB member since 2006-12-18)