Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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

  • Collect data from excel 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 to read this file into the new model you created in exercise 1:

  • Drag  - Add a new File Collector onto the modelling pane menu
  • In the new file collector form that pops up, enter the Name: Regions by County
  • Press 
  • You will now see the new file collector on the modelling pane
  • Save the model layout

Set up File Collector and Stream

  • Hover over your new File Collector, and press 
  • In the file explorer, go to: …\inputData\AddressCheck\regionsByCounty
  • Select the file regionsByCounty.xlsx and press Open
  • 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.

Pause file data

To pause the data loaded from the file:

  • Hover over the stream RegionsByCounty
  • In the hover menu press 

Run Analysis and view Stream data

  • Hover over your new stream, and press  - Run Analysis in the hover menu
  • Wait for your task to complete
  • View the data: hover over the stream and in the hover menu press  - Show the list of Stream Views
  • In the drop down list, select Default View
  • No labels