How to add data to an analysis
In Chapter 5, Source Data is Never Enough, we explored the notion that the source data might not be sufficient or in quite the right form for the analysis we want to do. It's always best to do as much data modeling and manipulation as possible at source, but if you need to do some additional data manipulation, scripting allows you to automate and control this activity.
Data can be added as columns or as rows, and it can be added from a variety of sources, including tables already present in an analysis file. The first step is to define or reference the data source using the Spotfire.Dxp.Data.Import classes. We can then move back to the Spotfire.Dxp.Data namespace to make the additions.
Define a data source
Data can come from many sources, and there is a class for each type. In this section, we're going to look at database sources, delimited text file data sources, information links, and sources within the analysis file. Once you have defined a data source, you...
