Versions Compared

Key

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

...

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 Image Modified Add a new File Collector onto the modelling pane menu
  2. In the new file collector form that pops up, enter the Name: Regions by County
  3. Press Image Modified
  4. You will now see the new file collector on the modelling pane
  5. Save the model layout

Set up File Collector and Stream

  1. Hover over your new File Collector, and 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, press Upload

You will see a stream appear on your model – PhixFlow has automatically configured the file collector and the stream to load the file into PhixFlow.

...

To pause the data loaded from the file:

  1. Hover over the stream RegionsByCounty
  2. In the hover menu press Image Modified

Run Analysis and view Stream data

  1. Hover over your new stream, and press Image Modified Run Analysis in the hover menu
  2. Wait for your task to complete
  3. View the data: hover over the stream and in the hover menu press Image Modified Show the list of Stream Views
  4. In the drop down list, select Default View