Skip to main content

Interactive Results Grid

The Interactive Results Grid (IRG) is located below the canvas in Live Query. After you run the workflow, it displays the data from the selected tool, as well as messages and errors created from running the workflow.

Live Query retrieves preview results incrementally instead of loading the complete result set into the browser.

View Metadata

After you run a workflow, the IRG 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:

  1. Select a tool or output in the workflow to populate the Results Grid.

  2. 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 IRG.

The IRG 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 the cells you want to copy.

  2. Right-click the highlighted cells and select Copy, or select MoreActions > Copy.

  3. Select one of the following options:

    • 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.

Retrieve Preview Data

The current IRG row window retrieves up to 500 rows per fetch.

When you first view the results, the browser receives up to 500 rows. If you scroll beyond the loaded rows, Live Query retrieves the next block of up to 500 rows.

The 500-row fetch size is common IRG behavior and isn't specific to an individual connector. It isn't currently a user-configurable setting.

Preview Caching

Live Query doesn't maintain a persistent Alteryx-side result cache for IRG results.

While the workflow page remains open, previously retrieved data can be stored in a page-scoped browser-memory cache. Live Query can display this data from the browser-memory cache. If you add a tool or change a tool configuration, Live Query runs a new query.

The underlying CDP might also use its own result-caching mechanism.

Protect Preview Data

Live Query transfers preview data over HTTPS within an authenticated user, workspace, and session context.

The page-scoped browser-memory cache is cleared when you refresh or close the workflow page.

Results Grid Table

The IRG table includes these items:

  • Calculate Total Rows: Calculates the number of rows in the table.

  • Columns: Select the Columns dropdown and check or uncheck columns to display in the IRG.

  • 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.

  • Data View and Metadata View: Select either the Data or Metadata to view the corresponding information in the IRG.

  • More Actions: Select More Actions 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 IRG in a new window.

Edit Data from the Results Grid

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

<listitem>

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. Go to 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)

</listitem>

Suggestions with Brushing

Within the IRG, 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:

  1. Select a tool on the canvas.

  2. In the IRG, select Messages to access the message view.

  3. Select a message type (Warning and Error).

Message Types

The IRG 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 tool name and tool ID in parentheses. Every tool in a workflow, including removed tools, is numbered.

Select the tool-name link in a message to select the tool and move the canvas so that the tool is visible.

In this section: