If you delete rows in a source dataset, you can restore the deleted rows from the row-level history. The deleted rows are loaded into a new dataset, and not into the original source dataset.

The row-level history displays a log of when you deleted rows from the source dataset. If you delete multiple rows at the same time, the history displays the deleted rows as a group entry. You can't choose from the history individual rows you want to restore. You can only restore the entire deleted row group entry.

To restore deleted rows:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Source data from the left-side panel.
  4. Find the source dataset from which you deleted rows from and want to restore.
  5. Select the Options icon to the right of the dataset, and then select Row Level History.
  6. Select the ellipsis icon to the right of the deleted row entry that you want to restore, and then select Restore.
  7. Enter a Name for the restored data, and then select Apply.

The restored row data displays as a new source dataset in the Source data inventory screen.