Reloading data results in duplicate rows being added.
Article ID: KB0081393
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All versions |
Description
It may happen when you have inserted columns to your existing data table, when reloading data, you see duplicate rows.
Issue/Introduction
Reloading data results in duplicate rows being added.
Resolution
Two possible sources for additional, "unexpected" rows, that being added to the Spotfire:
1. If we have only used left outer joins when adding new columns, it may still result in additional ("duplicate") rows being added, if there are multiple matches for an existing row (ID) in the new data. Using a "Left single match" join you can be sure there will be no additional rows.
2. After deleting rows, and saving the analysis with that data table set for "stored data", the deleted rows return when you reopen the analysis.
https://ideas.tibco.com/ideas/TS-I-6429
1. If we have only used left outer joins when adding new columns, it may still result in additional ("duplicate") rows being added, if there are multiple matches for an existing row (ID) in the new data. Using a "Left single match" join you can be sure there will be no additional rows.
2. After deleting rows, and saving the analysis with that data table set for "stored data", the deleted rows return when you reopen the analysis.
https://ideas.tibco.com/ideas/TS-I-6429
Feedback
Yes
No
Powered by
