Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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 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 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 Modified in the main pipe configuration form to save your changes

...