Versions Compared

Key

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

By the end of this chapter you will be able to:

  • Collect data from Excel Spreadsheetsexcel spreadsheets

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 file collector to read this file into the new model you created in exercise 1:

...

  1. Drag Image Modified

...

  1.  Add a new File Collector onto the modelling pane menu
  2. In the new

...

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

...

  1. Press Image Modified
  2. You will now see the new

...

  1. file collector on the modelling pane
  2. Save the model layout

...

Set up File Collector and Stream

  1. Hover over your new File Collector, and

...

  1. press Image Modified
  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 Stream stream appear on your model – PhixFlow has automatically configured the File Collector file collector and the Stream stream to load the file into PhixFlow.

...

Pause file data

To pause the data loaded from the file:

  1. Hover over the stream RegionsByCounty
  2. In the hover menu

...

  1. press Image Added

Run Analysis and view Stream data

  1. Hover over your new

...

  1. stream, and

...

  1. press Image Added Run Analysis in the hover menu
  2. Wait for your task to complete
  3. View the data: hover over the

...

  1. stream and in the

...

  1. hover menu press Image Added Show the list of Stream Views
  2. In the drop down list, select Default View