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 

   s in the toolbar to show the list of options.

2. Drag 

    onto the model.

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

4. Press 

   .

5. You will now see the new Regions by County file collector in the model.

6. Press

    in the toolbar to save the model.

Set up File Collector and table

1. Hover over your new Regions by County 

   , and press 

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 

   .

3. Press 

    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 

    in the hover menu.

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

   .

3. The data will show like the image below:

   1. Open

      

4. In the model window, click 

   .