Combine multiple row data into one cell

[system]

Hi,
I have data like this:

ID Value

---

1 Value1
1 150
1 10/10/2010
1 Value2
2 Value3
2 160

I join multiple tables and get multiple values for one ID.I am new to BOB. I want to have a report in web intelligence like this:

ID Value

---

1 Value1, 150, 10/10/2010, Value2
2 Value3, 160

How can I do this? I searched forum and found this :
We will create 4 measure object within the report to achieve this:

1. Create an object called Maximum using the function below:

     =Max ([Code]) In ([Date])
   

2. Create a concatenated object called Object 1 using the formula below:

   = [Code]+" , "+Previous(Self)  
   

3. Create another measure object called Object 2 using the formula below:

          =[Object 1] Where ([Code]=[Maximum])
   

4. Finally create an object called Code(s) as below:

   =If (IsNull(Previous([Object 2]));Substr([Object 2];1;(Length([Object 2])-3));
         (Substr([Object 2];1;(Pos([Object 2];Previous([Object 2]))-4)))) 
   

But this solution gives me #MultiValue error.

Any help will be apreciated.

---

bahriye (BOB member since 2010-07-14)

[system]

This flattening data into a single row business seems to be the hot topic lately!

Anyway, have a look at this post - might be a good starting point:

120×120 10.4 KB

I have a report showing Item, Price and colour like this: Item Price Colour A £1 black A £1 red B £2 green B £2.50 black I want to show item A in one row, (since both item code and price are same), like this Item Price Colour A £1 black, red B £2 green B £2.50 black How can I do this ? Thank you bulgaru10 (BOB member since 2006-12-15…

---

Atul Chowdhury (BOB member since 2003-07-07)

[system]

Thanks for your reply. I have to bind data into one cell and I have to seperate them with comma. My aim is to convert row data into a comma seperated list .

---

bahriye (BOB member since 2010-07-14)

[system]

Try this link.

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

Note: I tried the trick long enough in DeskI. I hope it should work in WebI too.

---

BO_Chief (BOB member since 2004-06-06)

[system]

Hi

1. Create an object called Maximum using the function below:

=Max ([Code])

Try with this else is as it is

Check your out put carefully

---

Rajubollas (BOB member since 2009-09-04)