system
June 23, 2010, 12:34am
1
Hi all
this is how data comes in the report
Col1 Col2 col3 col4
614201 6/12/2010 121213 HF 6/12/2010 121213 BG 6/14/2010 121219 HD 6/14/2010 121230 1/1/2009 1003038373 07 1/1/2009 1003038373 51 1/1/2009 1003038373 52 1/1/2009 1003038373 65 1/1/2009 1003038373
Blank spaces are null values
but requirement is
Col1 Col2 col3 col4
614201 6/12/2010 121213 HF;BG 6/14/2010 121219 HD 6/14/2010 121230 NULL 1/1/2009 1003038373 07;51;52;65;NULL
Tried to use the col4+previous(self) but it gives only 2 values concatenated, but i want all the values separated by";" when col1,col2, col3 rows data are same
thanks in advance
prabhu_pramod (BOB member since 2010-06-17)
system
June 23, 2010, 7:06am
2
You can go through This .
Second thing, you can use
=if(IsNull([object]);"NULL";[object]) to show NULL values.
Prashant Purohit (BOB member since 2009-02-18)
system
June 23, 2010, 3:28pm
3
Create Measure Object for Col4 in Universe
rpad(col4,length(col4)+1,’;’)
In properties tab put function as “Sum”
patriot3029 (BOB member since 2006-12-08)
system
June 24, 2010, 9:04pm
4
Create Measure Object for Col4 in Universe
rpad(col4,length(col4)+1,‘;’)
In properties tab put function as “Sum”
This is a very interesting solution to the problem. I believe you may have answered several individuals questions with this answer.
Any ideas on how to prevent duplicate data?
RothMan777 (BOB member since 2008-04-04)
system
June 24, 2010, 9:28pm
5
What do you mean by duplicate , Can you explain with example …
patriot3029 (BOB member since 2006-12-08)
system
June 24, 2010, 9:33pm
6
Create Measure Object for Col4 in Universe
rpad(col4,length(col4)+1,‘;’)
In properties tab put function as “Sum”
I am wondering if this really works
Other solutions to the original question can use these techniques:
Marek Chladny (BOB member since 2003-11-27)
system
June 24, 2010, 9:53pm
7
I tested this using City names. So if I have a table that contains rows like:
ID City
Using your suggestion above, I received:
What I would really like to see is the same list without the duplicate values:
Thoughts?
RothMan777 (BOB member since 2008-04-04)
system
June 24, 2010, 10:08pm
8
Try this …pull completed data for table and see with wich column these values are dividing .
I mean
Newyork
patriot3029 (BOB member since 2006-12-08)
system
June 24, 2010, 10:13pm
9
Hi Marek,
I am doing same thing , But you are using only 2 columns . My solution should work for unique records .
It is working for me fine on Oracle DB
patriot3029 (BOB member since 2006-12-08)
(BOB member since 2009-02-18)
(BOB member since 2008-04-04)
I don’t have an access to Oracle DB now to test it 
(BOB member since 2003-11-27)
(BOB member since 2008-04-04)