Interactive Results Grid

The Interactive Results Grid, or Results Grid, is located below the canvas in Designer Cloud. After you run the workflow, it displays the first 10 MB of data from the selected tool, as well as messages and errors created from running the workflow.

Note

You are only shown the first 10 MB of data in the Results Grid. If you cannot find the data you're looking for, try using a Filter tool or a Select tool to decrease the size of your dataset. Alternatively, collect new sample data to work with using Resampling. See here for more information on Resampling.

View Metadata

After you run a workflow, the Results Grid has the option to display metadata. Metadata contains the characteristics of data that passes in and out of a tool you've selected. Metadata includes Row ID, Name, and Type.

To view metadata:

Select a tool or output in the workflow to populate the Results Grid.
In the Results Grid header, select Metadata View.

View Data

After you run a workflow, you can view the tool input and output data. To view data, select a tool or anchor in the workflow. The data from the tool or anchor will be displayed in the Results Grid.

The Results Grid header displays the total number of rows in the data and which columns of data are shown. To hide columns of data from the results window, uncheck the column name in the Columns dropdown. To copy selected cells from the table...

Select and highlight the cells you want to copy.
Right-click the highlighted cells and select Copy, or select MoreActions > Copy.
- Copy With Headers or Selected Cells with Headers: Copies the highlighted cells with their headers.
- Selected Cells without Headers: Copies the highlighted cells without their headers.

Results Grid Table

The Results Grid table includes these items:

Number of Rows: Displays the number of rows that are shown in the table.
Columns: Select the Columns dropdown and check or uncheck columns to display in the Results Grid.
Turn on Profiling: Select this button to see an overview, or profile, of data for each column.
- After you enable profiling, each column header displays summary information, including the column name and a data quality bar.
- The column's data type is indicated by an icon to the left of the column name.
- A data profile chart or a list of the column's top values is displayed depending on the column's data type.
- For more information on profiling, see Data Profile.
Turn on Suggestions: Select this button and then a column to see suggestions for how to transform your data. Select Open Tutorial to see how suggestions are shown.
Data View and Metadata View: Select either the Data or Metadata to view the corresponding information in the Results Grid.
More Actions: Select the MoreActions to perform tasks.
- Copy: Select and highlight the data you want to copy.
  - Selected Cells With Headers
  - Selected Cells Without Headers
- Export as CSV: Export sample data from a tool's anchor to a CSV file.
Open in New Window: Opens the Results Grid in a new window.

The Results Grid also lets you make quick edits to your data and apply these edits to your workflow as tools. To edit data in a column:

Select the vertical ellipsis icon for the column that you want to edit, then select one of the options:
- Pin Column: Freeze 1 or more columns to the left side of the IRG when working with large datasets. Note that this option is only used for observation purposes and doesn't change the order of your columns.
- Autosize Column Width: Resize the column width to fit the column name header.
- Rename: Change the name of the column.
- Change Data Type: Allows you to change the data type of a column. Data types that can't be selected are grayed out. You can also change the data type by selecting the data type icon next to the column name. See Supported Data Types for a list of data types.
- Remove: All columns from the input data are shown by default. Use Remove to remove columns from the Results window.
- Filter: Select Filter to access filter options for the data profiling Results window. You can filter based on 4 operators:
  - = (Equals) allows you to select all data points equal to that value.
  - != (Not Equal To) selects all data points, except for those with the value selected.
  - Is Null selects data points in the column that are null, excluding empty values.
  - Is Not Null selects data points in the column that are not null.
- Sort
  - Sort A to Z: Sort ascending.
  - Sort Z to A: Sort descending.
  - Don't Sort: (Default)
If you apply the changes, note that the associated tool is added to the workflow directly after the tool where you made the edits.
Select Run Job to run your workflow and see the changes made in your data.

Suggestions - Brushing

Within the Results Grid, Brushing allows you to highlight a value with your cursor and see suggested transformations. After you highlight a value, the Suggestions Panel opens automatically with relevant suggestions for your data. Suggestions vary based on the data type of the column. Brushing suggestions are also editable to ensure you're transforming your data exactly how you want.

Tool Messages

To view messages about your workflow tools:

Select a tool on the canvas.
In the Results Grid, select Messages to access the message view.
Select a message type (Warning and Error).

Message Types

The Results Grid displays 2 message types:

Warning: Available computer memory is less than the preferred setting, or missing fields were detected. Warnings do not cause workflow failure but you should review them.
Error: A tool was not configured correctly.

Message Form

Messages are limited to 256 characters. Select a message to view the entire message.

Each message displays the name of a tool and the tool ID in parentheses. Each tool in a workflow, including tools that have been removed, is numbered. Tool ID indicates the tool number in the workflow.

Select the link to the tool name in a message to select the tool in the workflow—this automatically moves the canvas so that the selected tool is visible.

In this section: