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

• Collect data from a spreadsheet

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.
You will now add a new file collector to read this file into the Introduction to Modelling analysis model:

1. Hover your mouse over  Files in the toolbar to show the list of options.
2. Drag  File Collector onto the model.
3. In the New FileCollector settings on the right of your screen, enter the Name: Regions by County.
4. Press  Apply and Close.
5. You will now see the new Regions by County file collector in the model.
6. Press  Save in the toolbar to save the model.

Set up File Collector and table

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

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

Pause file data

To pause the data loaded from the file:

1. Hover over your new table Regions By County.
2. In the hover menu press Static.
3. Press  Apply and Close in the table settings.

Further information on pausing files can be found on 2 Reading data from files into PhixFlow.

Run Analysis and view table data

1. Hover over your new table, and press  Run Analysis in the hover menu.
2. Then view the data by hovering over the Regions By County table and pressing  Show view.
3. The data will show like the image below:
   1. 
4. In the model window, click  Save.