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

• Collect data from Excel Spreadsheetsexcel 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 file collector to read this file into the new model you created in exercise 1:

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

...

Set up File Collector and Stream

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

You will see a Stream stream appear on your model – PhixFlow has automatically configured the File Collector file collector and the Stream 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 press Image Modified

...

...

Run Analysis and view Stream data

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