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

• Collect data from excel spreadsheets

A file containing a mapping of Counties to Regions can be found in the input files, at:
…\inputData\AddressCheck\regionsByCounty\regionsByCounty.xlsx
You will use this data to find the Region for each of the customer addresses that you have already loaded. Notice that there is a header line in this file with the column names of the data.
Add a new file collector to read this file into the new model you created in exercise 1:

1. Drag  Add a new File Collector onto the modelling pane menu
2. In the new file collector form that pops up, enter the Name: Regions by County
3. Press 
4. You will now see the new file collector on the modelling pane
5. Save the model layout

Set up File Collector and Stream

1. Hover over your new File Collector, and press 
2. In the file explorer, go to: …\inputData\AddressCheck\regionsByCounty
3. Select the file regionsByCounty.xlsx and press Open
4. In the Upload Managed File form, press Upload

You will see a stream appear on your model – PhixFlow has automatically configured the file collector and the stream to load the file into PhixFlow.

Pause file data

To pause the data loaded from the file:

1. Hover over the stream RegionsByCounty
2. In the hover menu press 

Run Analysis and view Stream data

1. Hover over your new stream, and press  Run Analysis in the hover menu
2. Wait for your task to complete
3. View the data: hover over the stream and in the hover menu press  Show the list of Stream Views
4. In the drop down list, select Default View