The Monarch Data Prep Studio Toolbar and Windows

Application Menu

Allows you to:

• Open, close, and save your workspace

• Open a new data source

• Export and import Change Lists

• Open a table in Data Prep Studio in Classic mode

• Import workspace tables

• Launch a new Classic mode session

• Import workspace tables

• Close Monarch Data Prep Studio

• Exit Data Prep Studio

Start

Allows you to open a file. It also allows you to:

• View product-related videos.

• View online Help

• View Team Files

• Go to the Market Place.

Preview

Allows you to:

• Open a file to load a data  source or a report

• Preview and discover data within tables

• Select specific tables to work with

• Select and append similar tables prior to loading.

Prepare

Allows you transform the columns of your unified table. For instance, you can:

• Change the case

• Remove extra spaces

• Convert from one data type to another

• Work with substrings

Transform

Allows you to:

• Remove empty rows

• Pivot or unpivot columns

• Group rows by a specific column

Combine

Allows you to join data from two or more tables, so that you have one unified table to work with.

Analyze

Allows you to create, view, modify, and manage summaries

Export

Allows you to export your workspace to several popular file formats and file and database systems.

Report Design

Allows you to build a table by selecting fields on a document. The resulting table then becomes available in the Preview Window, so you can load it and then eventually combine with other tables or data sources.

This window is only available only when you open a report document.

Workspace Information

Clicking this icon launches a popup that provides complete details on your workspace.

Save Workspace

Allows you to save your current workspace. Your workspace includes:

• The tables you have loaded

• The join definitions you have created

• The transform operations you have carried out

Data Source Library

Opens the Data Source Library, which will then allow you to select and use data sources made available to you.

Settings

Presents setting options that allow you to, among others:

• Set row limits

• Set default folder values

• Configure advanced settings

• Define conversion settings

• Define server settings

• Specify runtime parameters

• Set time intervals

• Configure display settings

• Specify security settings

• Configure license settings

• View information on the Monarch Data Prep Studio application