Altair® Monarch®

 

The Monarch Data Prep Studio Toolbar and Windows

The Monarch Data Prep Studio interface includes a toolbar that remains visible regardless of the window or page you access.   

Hover on a tool to get a brief description. Click on the tool to go to the main help page of that tool.

The Monarch Data Prep Studio windows

Monarch Data Prep Studio has five windows, i.e., Start, Preview, Prepare, Combine, and Export, each of which allow you to carry out a specific action towards completing data integration, preparation, and transformation. These five windows can be accessed directly from the toolbar.  The Report Design Window becomes available only when you open or edit a PDF or report document.

When selected, the Combine and Analyze stages allow you to combine data by appending or joining and create summaries, respectively.

Window and tool Descriptions

Window

Description

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.

Object Description

Clicking this icon launches a text field into which you can enter a comment or description of the 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