âShow Table of Contents
The Browse tool displays data from a connected tool as well as data profile information, maps, reporting snippets, and behavior analysis information in the data.
Use a Browse tool as you build a workflow to get insight that helps you prepare, cleanse, and analyze data. You can also use a Browse tool to view all data from a connected tool in the Results window. Without a Browse tool, the Results window displays up to 1 MB of data from a tool. See Results Window.
Connect a Browse tool to the output anchor of the tool that contains data that you want to view in detail.
There are three ways to add a Browse tool to a workflow:
The Browse tool requires temporary space and memory on your computer which increases the size of data and may impact performance. After you build a workflow and are ready to output results, you can disable Browse tools in the workflow.
To disable Browse tools in a workflow:
To enable Browse tools, deselect Disable All Browse Tools, in the Workflow Configuration window on the Runtime tab.
View data in the Configuration window and the Results window. The Configuration window displays different charts and metadata depending on the type of data in the column selected in the Results window.
A colored data quality bar displays at the top of each column of data in the Results window.
By default, the first column of data in the Results window displays in the Configuration window. Click a different column to view its data in the Configuration window. See Results Window, for more on the Results window.
The following options are available in the Configuration window:
Left, right view: Click to view all tabs in the left and right halves of the window. Click different tabs in each window to compare data.
When a Browse tool is connected to a tool with string, numeric, or date/time data types, the Profile tab in the Configuration window displays a chart and metadata of the selected column. Click columns in the Results window to view data profile information for other columns.
By default, data profiling is enabled. To disable data profiling features, go to Options > User Settings > Edit User Settings and deselect Collect and display data profile information.
Different types of charts display in the Configuration window depending on the type of data in a selected column. When data in a selected column correlates with data in another column, the data may be combined and presented in a chart. For example, sales data from one column may be combined with dates in another column to create a chart with sales per month.
The bar chart depicts the frequency of a value, or grouped values, in data and includes a quality bar that summarizes data quality in four categories:
The scatter plot depicts the distribution of data and includes a range (box-and-whisker) plot that identifies the lowest and highest values, and the first quartile, median or second quartile, and third quartile values.
The metadata for the selected column displays below the chart in the Configuration window. Available metadata depends on the data type in the selected column. See Data Types, for a list of data types.
If the selected column contains string values, the following metadata is provided:
If the selected column contains numeric values, the following metadata is provided:
If the selected column contains date/time values, the following metadata is provided:
If the selected column contains spatial objects, the following metadata is provided:
The Basic Data Profile tool provides similar metadata without charts. Use the Basic Data Profile tool to output data profile information for further analysis. See Basic Data Profile Tool.
When a Browse tool is connected to a tool with reporting snippets the Report tab in the Configuration window displays the reporting snippets as they will appear in a report. Reporting snippets are created by tools in the Reporting category. See Reporting Tools.
Report view options include:
When a Browse tool is connected to a tool with spatial data the Map tab in the Configuration window displays a map of the data drawn in spherical Mercator projection.
Map view options include:
There are multiple supported selection methods. Select or click to enable, then deselect or click again to disable.
When a Browse tool is connected to a tool with behavior analysis profile data the Behavior Analysis tab in the Configuration window displays the XML content of a selected profile field, record-by-record, in a table.
Behavior Analysis view options include:
Use the Behavior Detail Fields tool to add the data available in this tab to a workflow. See Detail Fields Tool.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.