Filtering on pipes

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

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