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 of different products in the basket, one basket per record. It is then required to perform an aggregation using a Boolean OR
operation to produce one record per customer showing the products in all the baskets (that is, whether the customer...