About Change History

Monarch Data Prep Studio tracks all transformations that you carry out on a table, including those performed in the Preview and Prepare windows as well as in the Joining and Appending stages, and logs these in a change history list.

A change history is a record of all of the changes that have been made to a table or column, including any filter and row selection applied prior to loading. This list can be reapplied to any table that has columns of the same names and data types in the same order. Change histories may be imported and exported and applied to tables similar to that from which the imported/exported change history was created.

Using the change history, you can:

have a ready audit trail so you can review the transformations you have carried out,
undo changes,
apply changes to other columns in other tables within the Prepare Window, and
create a library of changes that you can export, import, and reuse in a different workspace

The Change History panel provides several tools that help you work with changes.

The table below describes these tools.

Tool	Description
General Tools
Drag-and-drop handle	Allows you to drag and drop the entire Change History list to another compatible table. When this is done, all of the changes indicated in the list are applied to all of the columns of the new table.
Undo change	Reverses the last change to the Change History list (e.g., addition of new change, grouping of changes, movement of a change up/down the Change list)
Redo change	Reverses the last undone change to the Change History list.
Collapse/Expand change group	Collapses or expands change groups.
Import change list	Imports a change list that is applied to all of the columns of the table into which it is imported.
Export change list	Exports a change list.
Add or Edit Macros	Allows you to add/edit macros.
Change-Specific Tools
Undo this change	Reverses the selected change. Note that all changes that appear above a change that is to be undone are also reversed. This tool specifically concerns column changes added to the Change History List.
Edit change	Launches a dialog that can be used to modify the selected change.
Object description	Launches a text field into which you can enter a comment or description of the change applied.

About Change History

Related Links