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
Learn more about Spotfire: http://spotfire.tibco.com/