You can preview data within transformation view datasets (also called derived datasets). You can also change how the data displays in the preview to help you locate specific rows in the dataset.
Dataset preview functionalities
With the dataset preview functionality, you can:
- Use a Boolean expression to filter the data that is displayed, based on values in the dataset.
- Sort the data that is displayed, based on the values in several columns from the dataset.
- Display up to 10,000 rows of data.
- Display the total number of rows in the dataset and the number that meet the filter conditions.
- Create a transformation view based on the filter definition.
- Export filtered data to a CSV file.
Manage data in the preview
You can manage how the data displays in the dataset preview.
Note that if you change how the data displays in the preview, you can't save the updated preview. The preview resets the next time you return to it.
Note: If you change how the data displays in the preview, you can't save the updated preview. The preview resets the next time you return to it.
To manage the data in the preview:
- Select Data Orchestrator from the top-left navigation menu.
- Choose a dataspace from the list.
- Select Transformation views from the left-side panel.
- Select the Options ellipsis icon to the right of the dataset row, and then select Preview.
- Use the toolbar options or the options listed under the Options ellipsis icon to manage the dataset.
See the tables below for more information about the options.
Toolbar options
Use the options that display in the toolbar to manage the data displayed in the dataset preview.
| Toolbar options | Description |
| Filter | Apply filters to the columns in the dataset preview. Select this option and set the filter in the right-side panel. If you apply a filter, you can export the filtered data, or create a new transformation view that includes only the filtered data. |
| Sort | Sort the columns in ascending or descending order. Select this option and set the column sort order from the right-side panel. |
| Copy to clipboard | Copy the all dataset items in the preview to your clipboard. |
Ellipsis options
To manage the dataset, use the Options ellipsis icon located at the top right of the preview screen. Additional options display when you select the Options ellipsis icon . The options that display are:
| Ellipsis options | Description |
| Create transformation view | Create another transformation view with this dataset. |
| Rename | Rename the dataset. |
| Export | Export the dataset as a CSV file. |
