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

• Set up simple pipe filters

Set up 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 Introduction to Modelling analysis model, add a new table:

1. Hover over the Reformatted Customer Details table, and press  Create New Table.
2. Give the new table the Name: Customers in England
3. Drag all attributes from the Reformatted Customer Details table to the new Customers in England table.
   1. 
4. Click on the pipe connecting the Reformatted Customer Details table to the Customers in England table.
5. Go to the Filter section and set the conditions as per the below image:
   1. 
   2. Then click  next to Where ANY of the following are true to add a new condition. 
   3. A new condition will appear - in the same way as for the first condition, add a condition as per the below image:
   4. 
   5. In the same way, add an additional condition as per the below image:
   6. 
6. At the top of the pipe settings, press  Apply and Close

Run analysis

1. Save your model layout.
2. Run analysis on the Customers in England table.
3. Have a look at the data in this table – check that the filter has been correctly applied. You should only see EAST, WEST and SWEST in the Region column.
4. In the model window, click  Save.