In Excel there is a function called 'Remove Duplicates' is there also such a function in Spotfire available

[Dan Verheijen]

I have many duplicates in my report which I like to have removed.

Is there a way I can do it in Spotfire

[Kirsten Smith (she/her)]

I would recommend that you vote for this suggestion in our Ideas Portal:

 

https://ideas.tibco.com/ideas/TS-I-6076

[Kevin Flynn]

I have created my own previously by using the "Rank" function. I would rank them by the columns that would determin duplicates.

An example would be this:

 

Case when Rank([invoicedAmount], "ties.method=first",[invoiceID]) > 2 then 'hide' else 'show' end

 

I would then use the filter to unclick the Hide, then hide the filter.