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:

• Drag  - Add a new File Collector onto the modelling pane menu
• In the new File Collector form that pops up, enter the Name: Regions by County
• Press 
• You will now see the new File Collector on the modelling pane
• Save the model layout

Set up File Collector and Stream

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

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:

• Hover over the stream RegionsByCounty
• In the hover menu press 

Run Analysis and view Stream data

• Hover over your new Stream, and press  - Run Analysis in the hover menu
• Wait for your task to complete
• View the data: hover over the Stream and in the tool bar press  - Show the list of Stream Views
• In the drop down list, select Default View