Combining mutiple rows in 1 cell?

building reports webintelligence
1

Can multiple rows be combined in a single cell in WebI? I’ve seen posts that say this cannot be done but I just wanted to check. For example I have 2 rows for a customer. Row A has a value of 722 and row B has a value of 551. I would like to have 722;551 in 1 cell. There can be an unlimited number of codes but I doubt more than 10. Can an array be built somehow in WebI? Thanks!

rdurbin9 (BOB member since 2008-04-03)

2

I was able to change the table to a horizontal table but is there another way? Thanks!

rdurbin9 (BOB member since 2008-04-03)

3

Thinking as I write… what about 2 separate queries? One with whatever makes row A unique and one with whatever makes row B unique. Then merge the dimensions, convert the two numbers to text and concatenate together in variable.

Would that work?

debbie

Debbie :uk: (BOB member since 2005-03-01)

4

The horizontal table seems to satisfy the needs of the end user but I will keep that in mind when I have to try this again! Thanks!!!

rdurbin9 (BOB member since 2008-04-03)

5

Hi

Write your objects select statement as below

select sysdate||’;’||sysdate from dual

It will works

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

6

Use the Previous() to get the previous record value.
Try sorting the output with Customer Id and create a new variable that concatenates the previous row’s value with current one.

dharru (BOB member since 2008-06-04)

7

Here is the soluition that I found for similar scenerio:

rimpa :india: (BOB member since 2008-04-14)