Page Comparison

By the end of this chapter you will be able to:

You will also learn how to pass only some records to the receiving stream using the Maximum Number of Records per Group option.

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

...

1. In the model, double-click on the pipe from the  Combined Updates stream.
2. Expand the Sort/Group section toolbar.
3. In the section toolbar, click

   Insert excerpt
   _stream_attributes _stream_attributes nopanel true

    (check Image Removed - Show Stream Attributes)?? . Phixflow opens a list of the attributes that the Combined Updates stream can pass to the pipe.
   
4. Drag in CustomerRef. By default, this attribute has Group ticked and Direction set to A-Z (ascending).
   This means the data records will be grouped by CustomerRef.
5. Drag in SalesDate. Double-click on SalesDate in the Sort/Group grid. PhixFlow opens a settings form for the attribute. In Basic Settings, set:
   • Direction: Z-A (descending)
     
   • Group: 

     Insert excerpt
     _check_box_untick _check_box_untick nopanel true

   • Click 

     Insert excerpt
     _finish _finish nopanel true

      to save the change and close the attribute settings.
     This means the data records will be sorted by date, with the most recent first. 
6. In the pipe settings → Sort/Group, set Maximum Number of Records per Group to 1.
   This means PhixFlow will pass only one record, the first and therefore most recent, to the receiving stream.
   
   
7. Click 

   Insert excerpt
   _save _save nopanel true

    to save the pipe settings, which should look like this:
   
8. In the model toolbar, click 

   Insert excerpt
   _save _save nopanel true

    to save the model.

...