...

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 Drag Image Modified - 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 Press Image Modified
• You will now see the new File Collector on the modelling pane
• Save the model layout

...

• 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 Image Added

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.

...

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

Anchor
_Toc442889056 _Toc442889056

Run Analysis and view Stream data

• Hover over your new Stream, and press press Image Modified - 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 press Image Modified - Show the list of Stream Views
• In the drop down list, select Default View