Click on thepin to keep the stream properties open. You will need it later
Expand
title
Explore the possibilities
Look in the Attributes section
You can see that PhixFlow has identified all the properties of the data columns (attributes) such as the type and length. If you want to make any changes to these ...
Expand
title
Step 3 Import the data
...
Expand
title
Details
You now need to load the spreadsheet that contains the data into your application.
Open your application.
Right-click
Insert excerpt
_model
_model
nopanel
true
and select
Insert excerpt
_add
_add
nopanel
true
. PhixFlow opens a properties tab for the model.
In Basic Settings > Name enter: Businesses
In the toolbar for the tab, click
Insert excerpt
_model_display
_model_display
nopanel
true
.
In the workspace on the left, PhixFlow opens an empty model.
To load the Excel file, drag a
Insert excerpt
_file_collector
_file_collector
nopanel
true
from the model toolbar into the model.
PhixFlow opens the properties for the file collector. Add a name: Business-File and
Insert excerpt
_save
_save
nopanel
true
the properties.
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
. Browse to the Excel file.
In the upload window, click the
Insert excerpt
_upload_button
_upload_button
nopanel
true
button. This process
automatically configures the file collector properties to upload the file
creates a stream ready to hold the data. Streams are like PhixFlow's internal spreadsheets.