Doug, I agree with the fundamental points you are making for getting the vendor to accept a standard .CSV output (without any double quotes).
However, what I don't understand is why the following results would occur in Cognos for HTML vs. .CSV output???

Column1  '"' || cast([Data Item1] as varchar(256)) || '" where Data Item1 = a
Column2  '"' || cast([Data Item2] as varchar(256)) || '" where Data Item2 = b

In HTML, output is:
"a", "b"

In .CSV, output is:
"a", """b"""

For the .CSV output, why isn't the double quote wrapping working consistently for the first column vs. all subsequent columns?
It doesn't even matter what the data type is - character, numeric, date - I always get the same formatted set of results. First column single double-quotes, subsequent columns triple double-quotes.
If it is a matter of wrapping double quotes in additional double quotes, why isn't it doing it gor the first column?

It just doesn't make sense to me, but again I could be misunderstanding something!

Adam.

Hi Team,

PFA, while printing inside content body and data is missing in html output.
Can you please check and gudie.

Hi Team,

PFA, while printing inside content body and data is missing in html output.
Can you please check and gudie.

How can individuals with Autism or Asperger's, known for their unique cognitive abilities and attention to detail, leverage the power of IBM Cognos Analytics for Big Data processing and interpretation? Are there specific strategies or tools within the software that could be particularly beneficial for neurodiverse individuals in this field?
 
Forum Asperger

I want to find keyword(s) in the text value. Im looking for AND/OR solution that the query loops in 1 text value for all keywords and then goes to the next.

Query sample that im currently using:
[Dataitem].[textvalue] CONTAINS 'Test1' OR
[Dataitem].[textvalue] CONTAINS 'Fox' OR
[Dataitem].[textvalue] CONTAINS 'Cat' OR
Etc...

I found a solution in SQL with cross join but this one needs to be done in Cognos Analytics, which I not found a good solution.

This topic has been moved to Announcements.

https://www.cognoise.com/index.php?topic=38317.0

This topic has been moved to Reporting.

https://www.cognoise.com/index.php?topic=38319.0

This topic has been moved to Reporting.

https://www.cognoise.com/index.php?topic=38327.0

Thank you, Adam, for the response

I did remove those columns, but it still gave me the same result.

After a while from posting this issue

The item seems not duplicated anymore.

However, new items shown have the same issue: they are duplicated 


I've attached a sample from the report. I grouped all the report columns, and I highlighted the item that is duplicated


All the item seems to work fine, but when you look at the column in the cells not merged as one Cognos start a new row, but the item in it

it happened from time to time in certain items

I think what you have shown are your two inputs:  The list of keywords for the filter and a sample text description.

Please show the expected outcome.  More sample text descriptions, at least one that contains none of the keywords, would also be helpful to better demonstrate the problem.