Results Window

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

View Metadata

Before you run a workflow, the Results window displays metadata which contains the characteristics of data that will go in and out of a selected tool. Metadata includes: Record #, Name, Type, Size, Source, and Description. The Source column contains the tool or file the data came from and may also contain additional information about installed data.

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

To view metadata...

Select a tool, or an anchor on a tool, in the workflow.
In Results, select Metadata.
Select an input anchor or an output anchor to compare input and output results.

View Data

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

To view data...

Select a tool, or select any anchor ( or ) on a tool, in the workflow.
In Results, click Data
Select an input anchor or an output anchor 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 that states that partial results are displayed.

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

Interact with Results

After you run a workflow, you can interact with the results. Interactions include search, data cleanse, filter, and sort. This changes the displayed results.

Search Results

To search results:

Select a tool, or select any anchor ( or ) on a tool, in the workflow.
In Results, select Data.
In Search, enter a character, number, word or phrase to find all results.

Alteryx searches each value in every row and displays all rows where the search you entered is found. For example, if you searched for the number "1", Alteryx displays all rows where the number "1" is found in any value.

Data Cleanse Results

To cleanse data in your results:

Select a tool, or select any anchor ( or ) on a tool, in the workflow.
In Results, select Data.
Hover over the column you want to sort. This will display the menu icon.
Select the menu icon to view the interaction menu.
Select Data Cleanse to view the data cleansing functions.
Choose the data cleansing function that you want to perform and select Apply. Refer to the Data Cleansing tool for detailed descriptions of the data cleansing functions.

Alteryx sorts the column and redisplays results. To cancel while the sort is running, select the cancel icon (X). To remove the data cleansing funtion, open the interaction menu and click Data Cleanse. Locate the action that you performed and undo it, then select Apply.

Sort Results

To sort results:

Select a tool, or select any anchor ( or ) on a tool, in the workflow.
In Results, select Data.
Hover over the column you want to sort. This will display the menu icon.
Select the menu icon to view the interaction menu.
Select Sort to view the sorting options.
Choose either the Sort Ascending or Sort Descending options and select Apply.

Alteryx sorts the column and redisplays results. To cancel while the sort is running, click the cancel icon (X). To remove the sort, open the interaction menu and click Sort > Don't Sort > Apply.

Filter Results

To filter results:

Select a tool, or select any anchor ( or ) on a tool, in the workflow.
In Results, select Data.
Hover over the column you want to filter. This will display the menu icon.
Select the menu icon to view the interaction menu.
Select the Filter option.
Select a filter condition such as equals, contains, <=, or Is Null.
If applicable, enter filter criteria.
Select Apply or press Enter.

Alteryx filters the column and redisplays results. To cancel while the filter is running, click the cancel icon (X). To remove the filter, access the interaction menu and click Filter > Clear.

Revert to Original Dataset

To reset and revert to your original dataset:

Perform a search, sort, or filter in the results grid.
Click the three-line menu icon at the top right of the results grid. You will find this icon next to Open results in new window.
Click Revert to original.

Alternatively, you can select a different tool or anchor, or select the canvas to undo and remove any search, sort or filter action.

Add Tools to Your Workflow

Add Data Cleanse, Sort, and Filter Interactions as Tools to Your Workflow

You can only add tools to your workflow from the Browse tool results or a tool's output anchor when there is no tool connected to the output anchor.

You can add the interactions, such as data cleanse, sort, and filter, to your workflow. The interactions you add to the workflow display as Alteryx Designer tools. For example, if you applied a sort to your results grid, you can add the Sort tool to the workflow. Alteryx adds the Sort tool pre-configured, using the sort configuration you applied to the Results grid. This changes the dataset.

To add tools to your workflow:

Select a Browse tool in your workflow, or click a tool's output anchor ( ) that has no other tools connected to its output anchor.
Perform a data cleanse, sort, or filter action on your dataset using the Results grid.
Once the data in your results grid updates, 2 new icons appear: Cancel Data Manipulations and Apply Data Manipulations.
Select Apply Data Manipulations to add pre-configured tools to your workflow (based on any data cleanse, sort, or filter actions that you performed).

Alteryx adds the tools to your workflow. Select Cancel Data Manipulations to restore the Results grid to its original state.

Results Table

The results table includes:

Data quality bar: A colored bar displays at the top of each column and indicates the quality of data.
- 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 containing spatial objects, the data quality bar reports the presence or absence values. The data quality bar does not display via the Metadata view and in columns that contain report snippets. Use a Browse tool to view spatial objects and report snippets. See Browse Tool.

Fields: Select the drop-down arrow and select fields (columns) to display in the window. You can also use the associated check box and "x" icons to show or hide all fields, respectively. These icons are only enabled when applicable. For example, the Show All Fields icon is disabled if all fields are already showing. Additionally, these items are disabled via the Metadata view.
Cell Viewer: The Cell Viewer is enabled for the Data view only. Select the drop-down arrow to view metadata for each data field (column), or the content of a selected cell. Click to show white space or hidden characters in the cell. Note that the paragraph icon is only enabled if applicable.
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 the 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.
: With a field selected, navigate up and down fields. These icons are only enabled when applicable.
Number of results: Displays the number of records displayed in Results out of the total number of records.
Cancel or Apply Data Manipulations: After you perform a data cleanse function, apply a filter to a column, or sort a column, you have the option to apply these changes to your workflow via associated tools. Note that these icons are disabled if you have not performed any data manipulations and are also disabled via the Metadata view.
- To add tools to your workflow, select the Apply Data Manipulations icon (checkmark).
  - Data Cleanse: When you perform a data cleanse action on a column, select Apply Data Manipulations. This adds a Data Cleansing tool to your workflow with the data cleanse action that you applied in the Results window.
  - Filter: When you filter a column in the Results window, select Apply Data Manipulations. This 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 adds a Sort tool to your workflow with the sort condition that you applied in the Results window.
- To revert any changes that you have made to the Results table (you can only do this before you apply data manipulations), 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. Note that the Search bar is disabled when you switch to the Metadata view.
Data and Metadata: Switch between the Data and Metadata views of the Results grid.
Actions: Use the Actions dropdown 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 switch between a Table view and the data Profile view associated with the Browse Tool. Choose from All Records or Selected Records.
Show and Hide Numeric Separator: To the right of the Actions menu, you have the option to show or hide numeric separators via the 000 icon. Numeric separators are hidden by default. You can specify the symbol that you want to use as the separator (in other words, a comma, period, etc.) via Localization User Settings. Keep in mind that this setting only affects how the numbers display in the Results window. It does not affect the data.
- Select 000 (Show Numeric Separator) to display numeric separators in the Results window. For example, if your thousands separator is a comma, then 1000 displays as 1,000.
- Select 000 again to hide the separators.
Input anchor: Click to view incoming data.
Output anchor: Click to view outgoing data.

Limitations

In some cases, data doesn't 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	Deselect Disable All Browse Tools in Workflow Configuration. See Browse Tool.
Limited Hard Drive Space

Workflow and Tool Messages

After you run a workflow, Results displays information about what happened during and after the workflow was 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...

Select a tool in the workflow (to view tool messages), or select the canvas (to view workflow messages).
Select Last Run or Configuration.
Select a message type.

To view messages after viewing data, click .

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. Using this feature may decrease workflow performance; only use it for debugging. See Workflow Configuration.

Before you run the workflow, Performance Profiling shows the amount of time required to retrieve metadata from data sources and pass the metadata to other tools in the workflow.