Results Window

Last modified: September 09, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

The Results window is located below the canvas in Designer Cloud. After you run the workflow, it displays the data from the selected tool as well as messages, errors, and links to output files created from running the workflow.

View Metadata

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

To view metadata...

  1. Select a tool in the workflow or anchor in the Results window.
  2. In Results, select Metadata.

View Data

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

  1. Select a tool in the workflow or anchor in the Results window.
  2. In Results, select Data.

The Results window 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...

  1. Select and highlight the cells you want to copy.
  2. Select Actions > Copy.
    • Selected Cells with Headers: Copies the highlighted cells with their headers.
    • Selected Cells without Headers: Copies the highlighted cells without their headers.

Results Table

The Results table includes these items:

Columns

Select the Columns dropdown and check or uncheck columns to display in the Results window.

Number of Rows

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

Actions

Use the Actions dropdown to perform tasks.

Copy: Select and highlight the data you want to copy:

  • Selected Cells With Headers
  • Selected Cells Without Headers
Data and Metadata

Select either the Data or Metadata to view the corresponding information in the Results window.

Data Profiling

Check Data Profiling to see an overview, or profile, of data for each column. After you enable Data 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 Data Profiling, go to the Browse tool.

Apply to Canvas

The Results window also lets you make quick edits to your data, and apply these edits to your workflow as tools. You have access to several options that are typically found in the Select, Filter, and Sort tools.

To edit data in a column...

  1. Select the vertical ellipsis icon for the column that you want to edit.
  2. Choose one of these options:
    • Column Position and Width
      • Pin to Beginning: Pin the column so that it stays at the beginning (left-most) of the list as you scroll through columns horizontally.
      • Pin to End: Pin the column so that it stays at the end (right-most) of the list as you scroll through columns horizontally.
      • Don't Pin: (Default)
      • Autosize Column Width: If rows in the column contain too many characters to show by default, use this option to expand the column width so that all characters show.
    • Rename: Select this option to rename your column and enter a new name directly into the column header.
    • Change Data Type: Change the data type for the column. Choose from one of the common options or select More Types for a full list.
    • Remove: Remove the column of data.
    • Filter: Apply a basic filter to the column.
      • Select an Operator. Only operators that are compatible with the column's data type are available.
      • Enter a Value for the filter and select Apply to save the filter.
    • Sort
      • Sort A to Z: Sort ascending.
      • Sort Z to A: Sort descending.
      • Don't Sort: (Default)
  3. Once you apply a change to a column, a blue dot displays in the column header to indicate that the column's data was edited.
  4. If you want to apply these changes to your workflow, expand the Apply to Canvas window. Any updates that you made are queued and available to apply.
    Thumbnail
  5. Select the Apply & Run button to apply the updates to your workflow, or select Reset to return the Results window to its original state.

If you apply the changes, note that the associated tool is added to the workflow directly after the tool where you made the edits.

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.

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.
  • Pre-run Check: View messages related to errors with the configuration of your tools.

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 Messages to access the message view.
  3. Select a message type (Info, Warning, Error, Conversion Error, and File.)
  4. Select Reset to view all messages.

Message Types

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

  • Info: Workflow was run, or data is flowing through a tool.
  • 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.
  • Conversion Error: Data could not be converted, or data can't fit in a field.
  • Files: Links to input, intermediate, or output files.

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.

Right-click a message to export it as a CSV file or Excel Export (.xlsx or .xml). 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.

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.