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.
Add a new file collector to read this file into the new model you created in exercise 1:

1. Drag  File Collector onto the model.
2. In the new file collector form that pops up, enter the Name: Regions by County.
3. Press  Apply and Close.
4. You will now see the new file collector in the model.
5. Save the model.

Set up File Collector and table

1. Hover over your new 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 Managed File form, press Upload.

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 the table RegionsByCounty.
2. In the hover menu press Static.

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. Wait for your task to complete.
3. View the data: hover over the table and in the hover menu press  Show view.
4. In the drop down list, select Default View.
5. In the model window, click  Save.