COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: thedon_1 on 02 Feb 2012 07:06:17 AM

Title: CSV removing duplicate columns
Post by: thedon_1 on 02 Feb 2012 07:06:17 AM
I have a list report in Cognos 8.3 in which I have the same column twice, once at the start and again towardws the end.
When I export as an Excel file, I get both columns but when exporting as a CSV, it only appears once, the second instance is removed.

Why is this and what should I do to fix this?

Thanks
Title: Re: CSV removing duplicate columns
Post by: Gopinath on 02 Feb 2012 07:52:58 AM
In CSV, the columns are rendered based on what data items you have in your Query, NOT based on what you have in your list.