Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Reloading data results in duplicate rows being added.
Solution:
It may happen when you have inserted columns to your existing data table, when reloading data, you see duplicate rows.
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
Comments
0 comments
Article is closed for comments.