Results Window

Version:
Current
Last modified: April 27, 2021

The Results window is located below the canvas in Designer. Before you run a workflow, the window displays the characteristics of the data that will go into the selected tool. After you run the workflow, it displays the data from the selected tool, a data quality indicator, and messages, errors, and links to output files created from running the workflow.

View Metadata

Before you run a workflow, the Results window displays metadata that contains the characteristics of data that passes in and out of a tool you've selected. Metadata includes Record #NameTypeSizeSource, and Description. The Source column contains the tool or file that the data came from and might also contain additional information about installed data.

After you run a workflow, the metadata that passes through a selected tool or anchor displays in the Results window. To view metadata...

  1. Select a tool, or an anchor on a tool, in the workflow.
  2. In Results, select Metadata.
  3. Select an input anchor or output anchor on the left side of the grid to compare input and output results.

View Data

After you run a workflow, you can view tool input and output data. To view data...

  1. Select a tool, or an anchor on a tool, in the workflow.
  2. In Results, select Data.
  3. Select an input anchor or output anchor on the left side of the grid to compare input and output results.

By default, the Results window displays the number of records shown in the window out of the total number of records in the data. For most tools, the Results window displays up to 1 MB of data, or up to 1,000 bytes of string data, for each tool anchor. If data exceeds 1 MB, the Results window displays a message stating that partial results are displayed.

  • To view all data from a tool in the Results window, add a Browse tool, and rerun the workflow.
  • To view more than 1 MB of data in the Results window without adding a Browse tool, adjust Memory Limit per Anchor in User Settings.

Results Table

The Results table includes these items:

Data Quality Bar

This colored bar displays at the top of each column (below the column header) and indicates the quality of the data. The bar might display a combination of these colors based on the breakdown of data quality in the whole column:

  • Green (Ok): Indicates values with no identified quality issues, for example, leading or trailing whitespace.
  • Yellow (Null): Indicates values that are null, excluding empty values.
  • Red (Not Ok): Indicates values with leading or trailing white spaces, or embedded new lines.
  • Gray (Empty): For string data, indicates values that contain at least 1 string with no values. If you convert strings to other data types, empties are converted to nulls.
  • Diagonal lines (Partial results): Indicates that the column contains more than 1 MB of data. The quality bar only reports the quality of the data currently displayed in the Results window.

In columns that contain spatial objects, the data quality bar reports the presence or absence of values. The data quality bar doesn't display in columns that contain report snippets. Use a Browse tool to view spatial objects and report snippets.

Fields

Select the Fields drop-down arrow and check or uncheck columns to display in the Results window.

Cell Viewer

Select the drop-down arrow to view metadata for each data column or the content of a selected cell. Select the paragraph icon to show white space or hidden characters in the cell.

Cell Viewer Details

  • Table schema (metadata) displays if no cell is selected.
  • Spatial information displays if a spatial object cell is selected.
  • PCXML code for a snippet displays if a report snippet cell is selected.
  • The record byte size displays if a row is selected.
  • A red triangle appears in the top right corner of a cell if string data contains anomalies. Examples of anomalies include...
    • Strings with leading or trailing spaces.
    • Strings with embedded tags.
    • Strings with embedded new lines.
    • Numbers rounded to six decimal places for viewing.
Number of Results

Displays the number of records that are shown in the Results table.

Up and Down Arrows

After you select a field in the grid, use the arrows to navigate the Results grid.

Cancel or Apply Data Manipulations

After you apply a filter to a column or sort a column, you have the option to apply those changes to your workflow via associated tools.

  1. To add tools to your workflow, select the Apply Data Manipulations icon (checkmark).
    • Filter: When you filter a column in the Results window, select Apply Data Manipulations. This action adds a Filter tool to your workflow with the filter condition that you applied in the Results window.
    • Sort: When you sort a column in the Results window, select Apply Data Manipulations. This action adds a Sort tool to your workflow with the sort condition that you applied in the Results window.
  2. To revert any changes that you have made to the Results table, select the Cancel Data Manipulations icon.
Search

Search for data within your results. Use the Enter key on your keyboard to execute the search and only show matching results in the Results window. Select the "x" icon to clear the search results and view all results again.

Data and Metadata

Select either Data and Metadata to view in the Results window.

Actions

Use the Actions drop-down to perform several tasks.

  • Export: Select to export results to a file. Choose to export All Records or Selected Cells. This option isn't available for partial results.
  • Copy to Clipboard: Select the data you want to copy:

    • All Records With Headers
    • All Records Without Headers
    • Selected Cells With Headers
    • Selected Cells Without Headers
  • New Window: Opens the results in a new window where you can toggle between a Table view and the data Profile view associated with the Browse tool. Choose from All Records or Selected Records.
Input Anchor

The Input anchor icon is available on the left side of the grid if the selected tool has an input anchor. Select the Input icon to view incoming data.

Output Anchor

The Output anchor icon is available on the left side of the grid if the selected tool has an output anchor. Select the Output icon to view outgoing data.

Filter

Hover your mouse over a column header and select the vertical ellipsis icon to access the Filter and Sort options. To filter your Results window data...

  1. Select Filter to create a basic filter condition like what is available via the Filter tool. The available filter operators vary based on the data type of the selected column.
  2. Create your condition and select Apply. The Results window refreshes and shows only the data that matches the active filter condition. The column where the filter was applied is indicated with a funnel icon.
  3. To remove the filter, hover over the filtered column and select the vertical ellipses icon. Select the "x" icon and the Results window refreshes to show data without the filter.

Add Filter Tool to Workflow

When you filter a column in the Results window, select the Apply Data Manipulations icon (checkmark). This action adds a Filter tool to your workflow with the filter condition that you applied in the Results window.

Sort

Hover your mouse over a column header and select the vertical ellipsis icon to access the Filter and Sort options. To sort your Results window by data from a single column...

  1. Select either the up (ascending) or down (descending) icons to sort your data.
  2. To remove the sort, select the vertical ellipses and select the "x" icon associated with the Sort option.

Add Sort Tool to Workflow

When you sort a column in the Results window, select the Apply Data Manipulations icon (checkmark). This action adds a Sort tool to your workflow with the sort condition that you applied in the Results window.

In some cases, data do not display in Results.

Reason Resolution
In-Database Tool Add Browse tool to workflow.
Map or Report Tool Add Browse tool to workflow.
Selected Disable All Browse Tools Uncheck Disable All Browse Tools in Workflow Configuration. Visit the Browse tool documentation for more information.
Limited Hard Drive Space  

Workflow and Tool Messages

After you run a workflow, the Results window displays information about what happened during and after the workflow run. There are 2 message views:

  • Last Run: (Default) View messages from the last time you ran the workflow.
  • Configuration: View messages about changes to a tool's configuration.

To view messages after you run a workflow...

  1. Select a tool in the workflow to view tool messages, or select the canvas to view workflow messages.
  2. Select the Messages icon to access the message view.
  3. Select Last Run or Configuration.
  4. Select a message type.

To view messages after viewing their data, select the messages icon.

Message Types

The Results window displays several types of messages and links to files:

  • Errors: A tool was not configured correctly.
  • Conv Errors: Data could not be converted, or data cannot fit in a field. You can select the number of Conversion errors allowed per workflow. Visit Workflow Configuration for more information.
  • Warnings: Available computer memory is less than the preferred setting, or missing fields were detected. Warnings do not cause workflow failure but should be reviewed.
  • Messages: Workflow was run, or data is flowing through a tool.
  • Files: Links to input, intermediate, or output files.
  • All: (Default) Displays all messages.

Message Form

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

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

To highlight a message, select the icon to the left of the message. Right-click a message to copy it to the clipboard or save all messages as a .txt file. Select a tool name, in a message, to select the tool in the workflow—this automatically moves the canvas so that the selected tool is visible.

Performance Profiling

If you select Enable Performance Profiling (Workflow Configuration > Runtime) and you run a workflow, messages in the Results window display the percentage of time spent processing each tool. If you use this feature, workflow performance might decrease. Only use it for debugging. Visit Workflow Configuration for more information.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.