Pentaho Data Integration Beginner's Guide

Time for action – using a Database join step to create a list of suggested products to buy

If your customers ordered a product that is out of stock you don't want to let them down, so you will suggest some alternative puzzles to buy:

1. Open the transformation for the previous tutorial and save it under a new name.
2. Delete the Text file output step.
3. Double-click on the Group by step and add an aggregated field named customers with the list of customers separated by a comma (,). Under Subject, select idcus and select Concatenate strings separated by, as Type.

   Tip

   Pay attention to the type that you choose! This one ends with a comma. There is another one without the separator. Do not confuse them!

4. Double-click on the Database lookup step. In the Values grid, ...