IBM SPSS Modeler Cookbook

Reformatting data for reporting with a Transpose node

The Transpose node is very useful for restructuring data. One way it can be particularly helpful is with reporting of results, especially when the data has many more columns than rows.

Getting ready

This recipe uses the datafile cup98lrn_reduced_vars3.sav and the stream Recipe – report with transpose.str.

How to do it...

To reformat data with a Transpose node:

1. Open the stream Recipe – report with transpose.str by navigating to File | Open Stream.
2. Make sure the datafile points to the correct path to cup98lrn_reduced_vars3.sav.
3. Insert an Aggregate node and connect it to the Type node.
4. Open the Aggregate node and in the Key fields: area, select TARGET_B as the field to aggregate. In the Default Mode: ...