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 ...