COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: far972 on 13 Nov 2009 11:00:31 AM

Title: Column titles into values?
Post by: far972 on 13 Nov 2009 11:00:31 AM
Hello All,

I have a series of columns titled A,B,C,D that I would like to convert their titles into values for a new column, E.

Is there a simple way to do this in Report Studio?

TIA,
Mike

Title: Re: Column titles into values?
Post by: jahnavi on 16 Nov 2009 02:15:22 AM
Concatenate all the columns into one dataitem
Title: Re: Column titles into values?
Post by: Sreeni P on 16 Nov 2009 10:19:39 AM
Use UNION , and concatenate those data item into a single data item value, hope this will work..as per ur requirement