Hi,
We have a table with data like as below
Object Characteristics
Apple Fruit
Orange Fruit
Orange Color
In the table, characteristics has 3 different value and any object can have all 3 or 2 or 1 number of characteristics. Now In the list report in cognos, We need to show characteristics as 3 columns such that for every object, all its characteristics appear in single row.
Expected output
Object Fruit Color Vegetable
Apple X
Orange X X
I tried having the 3 characteristics separated in 3 queries and then tried taking union but it didnt work out. Even tried using Repeater, but it throws error. Can you all please provide suggestion on how can this be achieved.
Thanks!
Quote from: Sumanjha on 28 Sep 2015 10:35:32 AM
Hi,
We have a table with data like as below
Object Characteristics
Apple Fruit
Orange Fruit
Orange Color
In the table, characteristics has 3 different value and any object can have all 3 or 2 or 1 number of characteristics. Now In the list report in cognos, We need to show characteristics as 3 columns such that for every object, all its characteristics appear in single row.
Expected output
Object Fruit Color Vegetable
Apple X
Orange X X
I tried having the 3 characteristics separated in 3 queries and then tried taking union but it didnt work out. Even tried using Repeater, but it throws error. Can you all please provide suggestion on how can this be achieved.
Thanks!
Take a look at the forum etiquette post. You need to tell us what type of data source you have and be more specific in your explanation of the problem. Saying it didn't work or threw an error without explaining more is not giving us enough information to help.
I did something earlier and it didn't work. I tried something else and it threw an error. Would you be able to tell me how to solve my problem? No...you'd need to know more, wouldn't you? The etiquette post explains this and provides some ideas on how to articulate more fully.