About: This article describes the Data View tab in Construct.
Purpose: Use a Data View tab to view a sample of the data records from the selected file.
Table of Contents
- Introduction
- Opening a Data View by Clicking "View Data"
- Data View Tab Toolbar
- Previewing Data
- Related Articles
Introduction
A Data View tab opens when a user selects Data View from the main toolbar or View Data when right-clicking on a connection table, input file, or run output node. The tab will display a sample of the data records from the selected table. The default sample is 10000 rows, so if the dataset is smaller than that, all records will be visible. The sample size can also be changed by adjusting the Total records queried number and then using the Restart query button.
The total number of columns and rows loaded in the dataset can also be viewed directly above where the data view starts.
Multiple Data View tabs may be open at once. Selecting View Data multiple times in a job will always open the data view in a new tab. Tabs can also be pulled away from the main window by dragging and dropping onto another monitor screen.
Opening a Data View by Clicking "View Data"
To view data within Construct, right-clicking any input node or output node (after running it) will produce a menu with a View Data option. In general, it is recommended to use a Temp Output node, and then View Data to observe your results while working with a job.
Data View Tab Toolbar
The Data View tab toolbar presents several options to configure the view to your needs. All columns from the dataset are displayed on the left side of the data view, and the check boxes next to each column name can be used to add or remove the field from the data view.
- Show All: Selects the check box for every field in the dataset and therefor displays all columns of the dataset in the data view.
- Hide All: De-selects the check box for every field in the dataset and therefore no columns are displayed in the data view. This can be useful if you want to simplify your data view and only hand select a few columns. Selecting only the columns you want to view can be easier than de-selecting all the columns you don't want to view.
- Sort Ascending: Sorts the column names alphabetically in an ascending order (A-Z).
- Sort Descending: Sorts the column names alphabetically in an descending order (Z-A).
- Search for column: Allows users to search for a column name within the column list.
Previewing Data
Nodes that are not input or output nodes, do not offer the same View Data menu option. Instead nodes that are typically found in the middle of a data process offer a Preview Data option.
This option allows you to query your data source(s) and view results. To preview data, right-click on any Input, Compile, or Process node and select Preview Data from the menu. This runs a sample set of records through the job up to and through the node where the preview was requested. This allows users to evaluate the results of their work at any point in the process.
The size of the sample set can be edited manually, and the default sample may be changed under the Tools > Options > General menu.
Note: Previewing data will run a query on your database and will not recognize any Cached data that is in place. Depending on the size and configuration of your data, this may not be an ideal way to view your dataset results. Using a Temp Output node and then the View Data option may be a better option in these circumstances.
Comments
0 comments
Article is closed for comments.