COGNOiSe.com - The IBM Cognos Community

In SQL it's easy to identify duplicate rows by using GROUP BY and HAVING:

SELECT [field1],[field2],COUNT(*)
FROM tbl
GROUP BY [field1],[field2]
HAVING COUNT(*) > 1                 (https://stackoverflow.com/questions/2594829/finding-duplicate-values-in-a-sql-table)

How can you achieve this in Cognos? Are there multiple ways, and if so, what would be the 'best' by convention?

Thanks all

Same thing, really.

create one data item

count(
  [any field you might have]
  for [field1],[field2]
)

and filter on that data item >1, with filter after auto aggregation.

Excellent! Have an appluad :)

glad I could help! :)