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 

   Insert excerpt
   _file_collector _file_collector nopanel true

    onto the model.
2. In the new file collector form that pops up, enter the Name: Regions by County.
3. Press 

   Insert excerpt
   _finish _finish nopanel true

   .
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

   Insert excerpt
   _file_collector _file_collector nopanel true

   , and press 

   Insert excerpt
   _upload_file _upload_file nopanel true

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 

   Insert excerpt
   _static _static nopanel true

   .

Run Analysis and view table data

1. Hover over your new table, and press 

   Insert excerpt
   _run_analysis _run_analysis nopanel true

    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 

   Insert excerpt
   _view_show _view_show nopanel true

   .
4. In the drop down list, select Default View.
5. In the model window, click 

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .