Within tables in Spotfire, some rows might repeat. Even though these rows may not be true duplicates, you might not want repeating rows to appear in your table visualization.

Example: Data sample with non repeating rows in orange.

Here is a trick to eliminate repeating rows

Step 1 – Insert calculated column, called Name Duplicate Rank
Calculation: Rank(RowId(),"asc",[Company Name]) in this case, I want to see unique Company Names

Step 2 – Apply to table
Right click table – Properties – Data – Limit data using expression – Column Name Duplicate Rank = 1

Step 3 – Test, test, test results to ensure your data is displaying at the correct granularity

Have fun!

Learn more about Spotfire: http://spotfire.tibco.com/