Surpress duplicates in a cross tab

Hello,

Just a quick question, Google didn’t help:

Tables in BIRT have this nice feature that let’s you surpress duplicates in a column.

Q: Is there a way how to do the same thing in a cross tab?

Hello @dr_snglr,

there is Duplicate Row Filter node which can help. Use it but don’t filter any row rather mark rows unique/chosen/duplicate. Then follow it with Rule Engine node to replace column of interest with empty string in case where row is marked as duplicate.

Br,
Ivan

1 Like