Page Comparison

...

• 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

...