The Prepare Window

1

The standard  Monarch Data Prep Studio Toolbar

Select a tool to move to the Start Page, Preview Window, Transform Pane, Combine Stage, Analyze Drop-down, or Export Window.

2

Table Selector

Lists all the tables you have selected and loaded from the Preview Window.

You can toggle viewing and hiding this panel by selecting the Hide/View Tables icon:

You can click on the drop-down arrow located to the right of each table to display an action menu.

3

Data Preview

Displays sample rows from the currently-selected table. The Data Preview panel allows you to visually confirm the data in your tables.

Icons on the header readily tell you a column's data type:

 Date/Time

 Number

 Text

You can easily change the data type of a column by clicking the data type icon and selecting a different data type from the options that display.

The heights of column headers and data rows can be modified by drag-resizing them in the Prepare Window. Row height changes are saved in the workspace and do not affect the values indicated in the Application Default Settings. Thus, when the workspace is reopened, the same row heights set by drag-resizing are preserved. 

4

Prep Data Operations

A drop-down list that displays when you right-click on a column or click on a column header. Select the operation from the drop-down list.

Operations that display are specific to the column's data type.

5

Navigation Bar

Provides ways to:

• Search for a specific column value:

• 

  Enter a value to search into the text field. Select Find Previous or Find Next to look for succeeding values in the table.

  • Display a specific row on the table:

  

  Enter a row value into the Row: box to go to a specific row. Use the arrows to move to the next  or previous set of rows, or go to the first or last row on the table.

  • Automatically increase row heights to fit multi-line data:

  • Show nulls in columns values using the null indicator .

  • Display white space on column values:

  

  When enabled, white spaces are represented by small dots. This feature allows you to verify, for example, how many spaces are between words in a value, so that you can account for this when you do string operations.

• View the number of columns, including hidden ones.

Hover over the Column label to find the total number of visible and hidden columns.

• Increase of decrease the size of the table text.

Slide this slider to the left or to the right to decrease or increase the font size of the column values.

6

Workspace Information

Click this icon to launch a popup that provides complete details on your workspace.

7

Save Workspace

Use this icon to automatically save your workspace.

8

Data Source Library

You can save workspaces and tables to the Data Source Library. Clicking this icon displays the Library dialog.

9

Settings

Click to set Current Workspace or Application Default settings.

10

Change History Panel

Click to hide or unhide the Change History Panel and work with Change History.

11

Action Bar

The buttons displayed in the action bar vary according to the active table displayed in the Prepare window. You can use these buttons to perform quick operations on your table, such as edit file paths or add metadata columns.  

12

Application Menu

Click on this button to display a menu showing additional Monarch Data Prep Studio options. You can:

• Open a Workspace

• Close a Workspace

• Save a Workspace

• Import or export the Change List

• Exit Monarch Data Prep Studio