Download the Excel file and add some text
Watch the Video
| Multimedia |
|---|
| name | Demo Build Step 2 Define and Load Data.mp4 |
|---|
|
How to
| Expand |
|---|
| title | Plan your data (optional) |
|---|
|
Before you start any PhixFlow project, it is important to understand your data and what you need to do with it. For large projects this means detailed analysis using an Entity-Relationship Diagram (ERD). For this example, a sales team is using an Excel spreadsheet to manage a list of customer businesses and associated contacts. You want to make it easy for the team to access and maintain the data. You also want to add some simple CRM functions, for example, to add descriptions about the business. 
PhixFlow has many options that you can use to define the data, its properties and relationships. But if you already have data available you can quickly and easily load it into PhixFlow. The following video guides you through this process. |
...
| Expand |
|---|
| title | Upload data into PhixFlow |
|---|
|
Create an analysis model- In the repository, right-click Analysis Model and to create a new model.
- Set Basic Settings > Name to
Businesses and click | Insert excerpt |
|---|
| _finish |
|---|
| _finish |
|---|
| nopanel | true |
|---|
|
. - PhixFlow opens a new empty model on the left.
Load the Excel file- Drag a
| Insert excerpt |
|---|
| _file_collector |
|---|
| _file_collector |
|---|
| nopanel | true |
|---|
|
from the model toolbar into the model. - Set Basic Settings > Name:
BusinessData, and click | Insert excerpt |
|---|
| _finish |
|---|
| _finish |
|---|
| nopanel | true |
|---|
|
. - 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. 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. 
|
...