Page Comparison

...

• 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 press Image Modified - Add a new Connector
  • Click on Latest Package Update to connect the pipe
  • Call the pipe in
• Drag all attributes from Combined Updates to Latest Package Update

...

• Double-click on the pipe from Combined Updates
• Go to the Sort/Group tab
  • Press Press Image Modified - Show the list of Attributes
  • Drag in CustomerRef
  • Drag in SalesDate
  • You will leave CustomerRef as a grouping attribute
  • You will update SalesDate to be a ordering attribute:
    • Double-click on SalesDate in the Sort/Group attributes list
    • Set the Sort Direction to Descending
    • Untick the Group flag
  • Press Press Image Modified
• Set Maximum Number of Records per Group to: 1

This setting means that for each key value – in this case for each value of CustomerRef – only the first record will be returned; since you have also ordered by SalesDate descending, this will be the latest record for each CustomerRef

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

...