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. |
Related Links
© 2024 Altair Engineering Inc. All Rights Reserved.