Preview Dialog

When you import data into Web, a preview of the data appears. You can select options to modify the data before it is imported, or make changes to the data after it is imported.

Note: Digital.ai Intelligence Applications automatically designates data columns in your file as attributes or metrics based on the values contained in each data column. Attributes appear with a green attribute icon. Metrics appear with an orange metric icon. A geographical attribute for locations such as cities, latitude, longitude, etc., appears with marker icon. You can manually designate data columns as attributes or metrics before the dataset is saved.

Access

To access the Preview dialog:

1. Create a blank dossier or open an existing one.
2. Choose Add Data > New Data, import your data using the Data Sources dialog, and click Prepare Data.
   or
   In the Datasets panel, click More next to the dataset name and choose Edit Dataset.

Fields

All Objects View : Click to display all objects, in all tables, on the All Objects View Dialog. You can define the data, using the same options listed in Preview area.

Wrangle : Click to prepare your data and improve its quality before import on the Data Wrangling Dialog.

Tables: Displays the tables to be imported. If you selected multiple files to create a multi-table dataset, you can change which file is previewed by clicking a different table. To define import options for a table, select the drop-down arrow next to the table name. The following list of options appears:

• Edit Table: Refresh the data from its source, after making changes.
• Rename: Rename the table.
• Delete: Delete the table before it is imported.
• Parse: Import your data in a tabular or cross-tabbed layout. You can also insert column headers into the data, if the file does not provide them.
  Note: The Parse Data option is not available if you are importing data from a database.
• Wrangle: Evaluate the quality and usability of the data. Additionally, you can refine the data to improve its quality before you import it into Web. For example, you can remove white space, filter data, delete duplicate rows or cells, find and replace data, and concatenate columns.
  Note: The Wrangle option is available for selected data sources.
• Define Relationships: Define how tables and columns are joined and used, and which tables are related to other tables.
• Show All Attribute Forms: Display all available attribute forms for all attributes in the table.
• Show All Columns: Select the columns to display.
• Group Partition: If there are tables that contain the same set of objects, you can group these partitions into a single table.

Data Preview: Displays a preview of the data to be imported. To define a data column, select the drop-down arrow next to the column name. The following list of options appears:

• Change Data Type: Change the data type of the data column.
• Define Geography: Assign a geo role to the data column to generate additional geographical data, for easier integration with map-based visualizations.
• Convert to Attribute: Define the data column as an attribute.
• Convert to Metric: Define the data column as a metric.
• Do Not Import: Remove this data column from the import process.
• Rename: Rename the data column.
  Note: You can also define data columns in the Tables area by right-clicking the data column. The same options listed above appear.
• Map to Project Attribute: Map an imported attribute within a dataset to an existing project attribute and its corresponding attribute forms.