Example Stream: Upload Data

The first example stream, 1_upload_data.str, is used to clean and upload data from a flat file into SQL Server.

Since Analysis Services data mining requires a key field, this initial stream uses a Derive node to add a new field to the dataset called KEY with unique values 1,2,3 using the IBM® SPSS® Modeler @INDEX function.

The subsequent Filler node is used for missing-value handling and replaces empty fields read in from the text file crx.data with NULL values.