Filtering on pipes

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

• Set up simple pipe filters

In this exercise you will create a pipe to filter out only customers in England (by filtering only regions in England):

• In your model, add a new Stream:
• Hover over Reformatted Customer Details, and press  - Add a new Stream
• Give the new Stream the Name: Customers in England
• Drag all Attributes from Reformatted Customer Details to the new Stream
• Double-click on the pipe connecting Reformatted Customer Details to Customers in England
• Go to the tab Filter:
  • Press  to add a filter
  • In the drop down menu that appears, select ANY item true
  • Under the new heading Where ANY of the following are true:
    • Press  to add a filter condition
    • In the drop down menu that appears, select the Attribute Region
    • Leave the operator as the default – equals
    • In the value box on the right-hand side of this condition, enter the value: EAST
    • In the same way, add a condition Region equals WEST
    • In the same way, add a condition Region equals SWEST
• On the main pipe details form, press 

This filter will match any record where the Region has the value EAST, WEST or SWEST (because you selected ANY item true).

• Save your model layout.
• Run Analysis on Customers in England
• Have a look at the data in this Stream – check that the filter has been correctly applied