...

In this exercise you will select the latest (most recent) sales record for each customer, from the set of combined updates you created in the previous exercise.

Create an Aggregate Stream

• Find the icon  - Add New Stream (Aggregate), and drag this onto the modelling pane
• Give this Stream the Name: Latest Package Update
• Add a pipe from Combined Updates:
  • Hover over Combined Updates and press - Add a new Connector
  • Click on Latest Package Update to connect the pipe
• Drag all attributes from Combined Updates to Latest Package Update

Set up Grouping and Ordering on input pipe

You will set up the grouping needed (by Customer Ref) on the input pipe to the aggregate stream – but also set up ordering of the data. Both of these are done on the pipe.

...

• Press  in the main pipe configuration form to save your changes

Test your new Stream

• Run analysis on your new stream
• Make sure that for all customers the most recent sales update has been selected