Page Comparison

Create an analysis model

1. In the repository, right-click Analysis Model and

   Insert excerpt
   _add _add nopanel true

    to create a new model.
2. Set Basic Settings > Name to Businesses and click 

   Insert excerpt
   _finish _finish nopanel true

   .
3. PhixFlow opens a new empty model on the left.

Load the Excel file

1. Drag a 

   Insert excerpt
   _file_collector _file_collector nopanel true

    from the model toolbar into the analysis model.
2. Set Basic Settings > Name: BusinessData,  and click 

   Insert excerpt
   _finish _finish nopanel true

   .
3. In the model, hover your mouse pointer over the file collector. PhixFlow displays a pop-up toolbar. Click 

   Insert excerpt
   _upload_file _upload_file nopanel true

   and browse to the Excel file: BusinessData.xlsx.

4. In the upload window, click the  

   Insert excerpt
   _upload_button _upload_button nopanel true

    button. PhixFlow creates a new stream and opens its properties.

   Expand
   title Explore the possibilities
   When you upload an Excel file, PhixFlow automatically sets many of the file collector and stream properties. There are many options that you can use to load different types of data from file. To connect PhixFlow to databases you can use a Insert excerpt _database_collector _database_collector .

   
   

Your model now looks like this.