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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Combine values for one column

Started by cosimaeo, 24 Jul 2024 05:25:38 AM

Previous topic - Next topic

cosimaeo

Hello everyone,

We often have several industries selected for our vacancies. If I now have a report on closed vacancies and the Industries column there, I get three rows for a job if the job has three different industries. This duplication makes it difficult to evaluate something later in Excel. So my question is: Is there a way to display all industries in one cell? Or is it possible to create a separate column for each individual industry so that the vacancy does not appear more than once? (I hope the screenshot makes it clearer).
Maybe a expression?

Thank you!

cognostechie

The easiest way will be to group the Job title and vacancies columns. That way, those two columns would appear only once even if there are multiple industries. Another way is to use a repeater table (not 100% sure as haven't tried this in years) in the industries column. Another way is the way I like - Hand write your own SQL which will create a comma separated list of the Industries and put it in one column.

cosimaeo

Quote from: cognostechie on 24 Jul 2024 12:12:14 PMThe easiest way will be to group the Job title and vacancies columns. That way, those two columns would appear only once even if there are multiple industries. Another way is to use a repeater table (not 100% sure as haven't tried this in years) in the industries column. Another way is the way I like - Hand write your own SQL which will create a comma separated list of the Industries and put it in one column.

Hello, thank you - just one question if I click on Vacancy title and then group and click on industry and group, everything still appears several times?

cognostechie

Group all columns except the Industry