If you are unable to create a new account, please email support@bspsoftware.com

 

Need to group similar items in a column of a second column in a single line

Started by carioca10, Yesterday at 05:32:50 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

carioca10

Yesterday at 05:32:50 PM Last Edit: Yesterday at 08:41:35 PM by carioca10
Need to group similar items in a column of a second column in a single line  in a report.

As follows:

Input

Field A   Field B
-----------   -----------
A1             B1
A1            B2
A2            B3
A3            B4
A3      B5

It would become:

Output   
Field A      Field B
------------      -----------
A1         B1, B2
A2         B3
A3         B4, B5

Cognos Version 12.0.4
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite