You are here: Data Riser Bar>Viewing Your Data>Viewing the Data in a Table

DataFlux Data Management Studio 2.7: User Guide

Viewing the Data in a Table

Overview

You can quickly review the data in a selected table by using the Data Viewer tab to display the data. You can also use this tab to search, filter, or sort the data; save it as a query or profile; or generate a simple reporting graphic based on the data.

You can display this tab in any context in which a table can be selected such as the Data Connections Riser or a query flow. The Data Viewer tab enables you to perform the following tasks:

Note that you can also preview the results of a node in a data job by selecting the node and clicking the Preview tab in the Details pane. When a node cannot be displayed, an icon is shown on the node. Put your cursor over the icon to see why the preview failed.

Navigate the Data

You can easily navigate in the table data. You can use the navigation tools to perform the following tasks:

Search the Data

You can click Find to display the search fields for the data viewer. You can use these fields to perform the following tasks:

Note Note: Use the following syntax to search for empty strings, nulls, and null strings: 1) Leave the Find field empty to search for empty strings; 2) Enter (NULL) to search for nulls; and 3) Enter "(NULL)" to search for null strings. Note that some databases do not support null strings and will not return a result for them.

Filter the Data

You can click Filter to filter the rows and fields that are displayed in the data viewer. You can use the Filters dialog to perform the following tasks:

Note Note: You can change this setting globally in the Default max rows field in the DataFlux Data Management Studio Options dialog at Tools > Options > DataViewer. The value that you set in the Options dialog determines the sample size for all tables when they are displayed in the Data Viewer tab.

Note that the SELECT statement generated by each filter is displayed at the bottom of each filter tab.

Sort the Data

You can click Sort to access the Sort dialog. Then, you can use the dialog to set the sort fields, order, and direction in the data viewer. You can use Shift-click on consecutive column headers to add additional columns to the sort criteria.

Save as an SQL Query

You can click Save as SQL Query to access the Save Query dialog. Then, you can use the dialog to name the query and select a save location for it.

Profile the Table

You can click Open Profile Report to view an existing profile that includes the selected table. You can also click New Profile Report to access the New Profile dialog. Then, you can use the dialog to name the profile and select a save location for it. You can also see a list of existing profiles.

Open the Report Pane

You can click Open report pane to display the report pane for a selected field. Then, you can perform the following tasks:

Note Note: You can set options for the data viewer in the DataViewer section of the Data Management Studio Options dialog. You can access this dialog from the Tools menu.

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_T_TableExam_DView.html