Adding data
Your second step towards a complete app is associating and then loading the data.
You will associate the following files:
-
Cities.xlsx
-
Customers.xlsx
-
Item master.xlsx
-
Sales rep.csv
-
Sales.xlsx
Associating data
In the Associations view of the Data manager your data is illustrated using bubbles, with each bubble representing a data table. The size of the bubble represents the amount of data in the table. Bubbles marked with * indicates a new or updated table. You should see five data tables.
Now it is time to create an association between the fields in your tables Sales and Sales rep.
Do the following:
-
Drag the Sales rep bubble towards the Sales bubble.
The Data manager now detects a recommended association to the Sales table. This bubble is marked with green.
-
Drop the Sales rep bubble onto the Sales bubble.
A link is now created between the bubbles and the tables are associated using the recommended fields.
-
Click the link between the Sales rep bubble and the Sales bubble.
The association panel, at the bottom of the screen, displays a preview of data in the associated fields.
- Click the association Sales rep ID-Sales Rep Number in the association panel and rename it Sales Rep Number.
The association is now named Sales Rep Number.
Adding and associating more data
You have already associated the tables Sales and Sales rep. Data manager helps you identify recommended associations.
Do the following:
-
Click and hold the bubble Customer.
The bubbles Sales and Cities are marked green because Data manager highly suggests associating these two tables to Customers.
-
Click and hold the bubble Cities.
The bubble Customer is marked green. The bubble Sales is marked orange, which indicates a medium recommendation.
-
Click and hold the bubble Item master.
The bubble Sales is marked green.
Recommended associations are identified between all tables. You will now let the Data manager create the associations for you.
Do the following:
-
Make sure the Recommend associations pane is open on the right. If it is closed, you can open it by clicking .
-
Click Apply all.
The tables are now associated according to these recommendations. The five tables are all linked.
Now you can load the data.
Loading data
Now you have added all data files and associated their tables. Before you start building your app you must load the script.
Do the following:
-
Click Load data.
A progress window is displayed while the data is loading. When the data load is complete, you can continue.
-
Click Close.
Viewing the data model
Now you are ready to start building your app. Before you start, take a look at the data model.
Do the following:
- In the toolbar, open the app navigation menu and select Data model viewer.
- In the toolbar in the Data model viewer, click to expand the tables.
All tables are now connected and the Data model viewer should have the following content. A field connecting one or more tables is called a key.
You have now finished adding data and can start building your app.