Action History

Action History makes going back to older versions of your data easy. Action History allows you to view all the actions performed on your data in a specific worksheet and freely reorder, deactivate, reactivate, and delete the actions at any time.

Select History in the bottom corner of the right side panel to access your action history. You can perform the following operations on your actions in the History pane:

Operation

Description

Example

Deactivate

Deactivating an action marks the action as inactive and reverts its changes to the data in the worksheet without affecting the state of any prior or subsequent actions.

To deactivate an action:

  1. Select the circular icon at the bottom of the listed action.

  2. Click the check mark icon at the top of the History pane to apply this operation.

A deactivated action appears grayed out in Action History.

If you decide that you want to go back to viewing uncleansed data after cleansing a worksheet, simply deactivate the cleanse worksheet action; this does not affect any prior or subsequent actions to the worksheet.

Activate

Activating a previously deactivated action marks the action as active and re-applies the action to the data in the worksheet without affecting any prior or subsequent actions.

To activate an action:

  1. Select the circular icon below a deactivated action.

  2. Click the check mark icon at the top of the History pane to apply this operation.

If you want to see your cleansed data after having deactivated that action, you can activate it again to go back to the cleansed data view.

Delete

Deleting an action permanently removes it from Action History and reverts its changes to the data in the worksheet.

To delete an action from the action history:

  1. Click the trash icon below the listed action.

  2. Click the check mark icon at the top of the History pane to apply this operation.

Note
Until you apply the changes to the History pane, you can undo a delete by clicking the arrow icon that appears in place of the trash icon.

If you had changed a column to lower case and want to permanently remove that action, you can delete the action from Action History.

Reorder

Change the order in which the actions are applied by dragging and reordering the actions.

Click the check mark icon at the top of the History pane to apply this operation.

If you want to apply a split action only on cleansed data, you can reorder the actions so that the split action comes after the cleanse action.

Reverse Order

Reverse the order of actions to show the oldest action at the top of the list by clicking the icon in the menu bar at the top of the History pane. You can change the order back to the default order of most recent action first.

If there are many actions in the History pane and you want to view the oldest actions first, click the change order icon in the top menu bar.

Show Details
Show the following information for each action by clicking the expand icon below the listed action:

  • Action description

  • Author

  • Date applied

  • Category

    Possible values include Create, Conversion, Refine Column, Refine Worksheet, and Data Quality.

  • Column applied to

For the Edit Cell, Harmonize, and Replace actions, Action History shows the following additional information:

  • To: After value

  • From: Before value
If you want to see who performed a Replace action and what the before and after values are, you can show the details to see:

  • The user ID listed in Author

  • The after value in the To field

  • One or more before values in the From field

Export

Export the actions in Action History to a flowgraph by clicking the icon in upper right corner. You can run this flowgraph in SAP HANA Enterprise Information Management.

If you want to remove duplicate records and cleanse data in a similar data source that is constantly being updated, you can export these actions to subsequently perform them periodically on the updated data in SAP HANA.

Filter

Defining filters on your action history displays a subset of the actions in the History pane.

If there are many actions in the History pane and you want to view Refine Column actions performed by User1 on a specific date, you can define three filters to show only these actions. For more information, see Filter Action History.
Note
If another action depends on the action that you are performing an operation on, the system displays an error message.