Spotfire Ideas Portal
Often, multiple sources of data have different level of 'complete cases' - dataset #1 may have 60% filled entries, while dataset #2 may have the remaining 20% that are missing from #1 (both datasets may have all or some columns matching). Currently, an R merge, conditioned with matching column names and key index does the trick, but a native Spotfire functionality will be useful for non-coders.
The deduplication step following Add Rows/Columns is a pain.
Please provide more details on what is not covered by today's Add rows and Add columns operations in Spotfire.