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.