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

1. file collector form that pops up, enter the Name: Regions by County

1. .
2. Press 

   Insert excerpt
   _finish _finish nopanel true

   .
3. You will now see the new

1. file collector in the model.
2. Save the model

1. .

Set up File Collector and

table

1. Hover over your new

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

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

1. table RegionsByCounty.
2. In the hover menu

1. press 

   Insert excerpt
   _

1. static _

1. static nopanel true

   .

Run Analysis and view

table data

1. Hover over your new

1. table, and

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

1. table and in the

1. hover menu press 

   Insert excerpt
   _view_show _view_show nopanel true

   .
2. In the drop down list, select Default View.