O'Reilly logo

IBM SPSS Modeler Cookbook by Scott Mutchler, Tom Khabaza, Meta S. Brown, Dean Abbott, Keith McCormick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Multiplying out using Cartesian product merge, user source, and derive dummy

To produce every combination from two or more sets of records requires a Cartesian product operation. The recipe Cartesian product merge using key-less merge by key shows the simplest way of doing this in Modeler, by using a key-less merge. The current recipe shows a different method of generating a Cartesian product that uses dummy keys; this method dates from before the key-less merge operation was included in the software. This recipe also illustrates a slightly different data preparation situation; that is, in this case a set of 1000 customer records is multiplied out with a set of codes, the result being each customer record is duplicated and appended to each available ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required