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 

   Insert excerpt
   _file _file nopanel true

   s in the toolbar to show the list of options.
2. Drag 

   Insert excerpt
   _file_collector _file_collector nopanel true

    onto the model.
3. In the New FileCollector settings on the right of your screen, enter the Name: Regions by County.
4. Press 

1. Insert excerpt
   _finish _finish nopanel true

   .
2. You will now see the

1. new Regions by County file collector in the model

1. .
2. Press

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

    in the toolbar to save the model.

Set up File Collector and

table

1. Hover over your new

1. Regions by County 

   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

1. File

1.  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

1. your new table Regions By County.
2. In the hover menu press 

1. Insert excerpt
   _static _static nopanel true

   .
2. Press 

   Insert excerpt
   _finish _finish nopanel true

    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

1. table, and press 

1. Insert excerpt
   _run_analysis _run_analysis nopanel true

    in the hover menu

1. .
2. Then view the data by hovering over the Regions By County table and pressing 

   Insert excerpt
   _view_show _view_show nopanel true

   .
3. The data will show like the image below:
   1. Image Added
4. In the model window, click 

   Insert excerpt
   _save_saveModel _save_saveModel nopanel true

   .