Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: srinivas.inbox83 on 18 Apr 2014 03:08:22 AM

Title: eliminating duplicate records when there is one null and one value
Post by: srinivas.inbox83 on 18 Apr 2014 03:08:22 AM
Hi all

Code   title  ExecName  date
A          1       NULL        02/28/2014
A          1       Sri            02/28/2014
B          2       NULL        01/28/2014
C          3       Phani          02/01/2014
D          4       XYZ          02/05/2014
E          5        NULL       02/09/2014
F          6         Raj         02/15/2014
F          6         NULL      02/15/2014

I want to eliminate NULL values only when the records or duplicated , like for A and F   I want to show non null values only (display only one record), and keep NULL values when there is no duplication like for B and E records though Exec Name is NULL still it has to show in the report .

I can not put Exec Name is not NULL , if so other records B and E will be eliminated

Please help me out how to resolve this

Thanks ...
Title: Re: eliminating duplicate records when there is one null and one value
Post by: Raghuvir on 18 Apr 2014 07:06:29 AM
Hi Srinivas,

Why do u want to display NULL vales ?

Regards
Title: Re: eliminating duplicate records when there is one null and one value
Post by: Raghuvir on 18 Apr 2014 07:10:08 AM
How about just displaying the executive names which are present in the "ExecName" query itme ?

Let us know about your thoughts on this.

Regards
Title: Re: eliminating duplicate records when there is one null and one value
Post by: srinivas.inbox83 on 18 Apr 2014 07:12:45 AM
The Exec Name is NULL but not the entire record is NULL (insted NULL say it as  blank ,  assuming the employee name is not loaded ) ryt , so if I keep the filter as Exec Name is NULL then the duplicate record will be eliminated but along with the other records for which Exec Name is NULL/Blank (which is a single record in my ex. code B and E) will also be eliminated ryt ? which should not be

Regards
Srini
Title: Re: eliminating duplicate records when there is one null and one value
Post by: Lynn on 18 Apr 2014 09:01:00 AM
You could try setting the aggregate function for ExecName to maximum. If your query is set to auto group and summarize and all other values are duplicated it should give you what you want.
Text only | Text with Images