Import to build dimensions, measures and tables, as well as uploading your data.
In addition to uploading data, importing is a great way to start building the list dimensions and measures of your apps.
For importing to update the app with the latest upload data go here.
Adding a table using import
Start with and select . Explore to the target CSV file and select it.
Upon selection the import menu appears, with a table preview (the table name will update to the import file name) behind showing a table view of the CSV file header rows and data.
Import menu walkthrough
- Use the number box to select how many header rows before the data rows. The indicator will will move up/down in the table to confirm.
- The map import section instructs how to import each column of the import file. Uncheck to ignore that column.
- For any linked dimensions confirm how a future import would update to add new, refresh all or not update.
- Click and define how to import, using replace or add, into the selected target version.
- Click to . You can perform quick checks via confirming row count during the import menu and after import compare totals. The new table will contain an ID dimension to identify each unique row.
Example of CSV import file and uploaded table
Working with an import table
The new table can now be worked with like any other table. For example:
- Add a calculation measure to enhance the imported data.
- Add a new or existing dimension into the table for additional analysis.
- Pivot the table to analyze data, filter and sort, update layout, save detailed and summary table views. In the example below, the summary table view shows performance by quarter by product and product size, a table view built from the import detail.
Table views leverage combinations of pivoting and slicing with display modes.