Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

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 

...

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

...

  1. Insert excerpt
    _finish
    _finish
    nopaneltrue
    .
  2. You will now see the new file collector

...

  1. in the

...

  1. model.
  2. Save the model

...

  1. .

Set up File Collector and

...

table

  1. Hover over your new

...

  1. Insert excerpt
    _file_collector
    _file_collector
    nopaneltrue
    , and press 
    Insert excerpt
    _upload_file
    _upload_file
    nopaneltrue
  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

...

  1. table RegionsByCounty.
  2. In the hover menu press 

...

  1. Insert excerpt
    _static
    _static
    nopaneltrue
    .

Run Analysis and view

...

table data

  1. Hover over your new

...

  1. table, and press 

...

  1. Insert excerpt
    _run_analysis
    _run_analysis
    nopaneltrue
     in the hover menu.
  2. Wait for your task to complete.
  3. View the data: hover over the

...

  1. table and in the hover menu press 

...

  1. Insert excerpt
    _view_show
    _view_show
    nopaneltrue
    .
  2. In the drop down list, select Default View.