Shuffle-down (nonstandard aggregation)
Some applications require a form of aggregation not directly supported in Modeler, for example, aggregating a set of Booleans or Flags with a logical or Boolean operator such as OR
. This recipe shows how to combine sorting with sequence functions in filler nodes to perform nonstandard aggregations.
This technique originates with basket analysis using versions of Modeler that pre-date the inclusion of the SetToflag node. Without the Set-to-flag node, when an analysis required aggregating a set of Booleans, it was necessary to construct the required technique out of the then-existing nodes. Typically, this processing step started with multiple records for each customer, with several fields representing the presence ...
Get IBM SPSS Modeler Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.