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 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:
- 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 hover menu press
Show the list of Stream Views - In the drop down list, select Default View