Cartesian product merge using key-less merge by key

Preparing data for analysis requires a wide range of different operations, because each different kind of analysis requires the data to be in the appropriate form for that analysis. In some examples, two or more lists of items must be joined together in such a way that the result is every possible combination of items, one from each of the lists. This is called a Cartesian product, and in Modeler this is performed using a merge by key operations where no key is specified.

Getting ready

This recipe requires no datafile because the example data is generated by user input source nodes and the stream file required is Cartesian_Product.str

How to do it...

To perform a Cartesian product merge where no key is specified:

1. Open the stream Cartesian_Product.str by navigating to File | Open Stream.
2. Run the four Table nodes to the left, ABC, PQR, XYZ, and 123. This will display the four data sets, generated by the user input source nodes, that will be used...