COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: neetw on 10 Aug 2022 12:44:35 AM

Title: Displaying array variant fields from Snowflake DB in Cognos CSV report
Post by: neetw on 10 Aug 2022 12:44:35 AM
Hi,
By default the cognos csv report is tab delimited. Is there any way in which the delimiter can be changed on report levels to either comma or pipe delimited?

I have an array variant field in the database which looks like {"key1":"value1","key2":"value2"} . When i create a csv report with this field, it shows up as "{""key1"":""value1"",""key2"":""value2""}"

Is it possible to have it displayed as {"key1":"value1","key2":"value2"} in the csv report?


Thanks,
Neet