Merging data from multiple sources
It is best practice to transform your data, including merging from multiple sources, before it arrives in your analysis tool. However, you might not have this facility or access to good data integration tools, or perhaps you just want to explore something quickly to follow an analytical hunch. Spotfire provides some easy-to-use and powerful data merging tools.
When merging data into an existing data table, the first thing you have to decide is whether you are adding new columns or new rows. Then, you must define how the data sets are related. If you are adding new columns of data, you must define the key columns in each table that link the two data sets uniquely for the columns you add. If you are adding new ...
Get TIBCO Spotfire – A Comprehensive Primer now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
