The Browse icon is a set of binoculars.

Browse Tool

Version:
Current
Last modified: December 30, 2019

Use the Browse tool to display data from a connected tool, as well as data profile information in a single column such as the data types, like string, number, and date. There is an additional tab in the Browse tool when spatial, report, or behavior analysis data types are connected, and will show a preview of the actual spatial object on a map, or the report.

Configure the Tool

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:

  1. Drag a Browse tool to the canvas and connect it to a tool.
  2. Right-click on a tool and select Add Browse after.
  3. Press Shift + Ctrl + B and select the tools in a workflow.

Without a Browse tool, the Results window displays up to 1 MB of data from a tool, by default. The Browse tool can be disabled if you don't want to store the entire dataset in the memory -- modify the default setting in the User settings.

To disable Browse Tools in a Workflow

  1. Click the canvas to display the Workflow Configuration window.
  2. In the Configuration window, click Runtime.
  3. Select Disable All Browse Tools. The Browse tools in the workflow are grayed-out.

To enable Browse tools, deselect Disable All Browse Tools in the Workflow Configuration window on the Runtime tab.

Metadata

Date/Time Data

If the data stream contains a date/time column and you select a numeric column, the numeric values are grouped by date/time.

Example: Sales data from one column may be combined with dates in another column to create a chart with sales per month. Use the arrows or chart icons to move between multiple charts.

If the selected column contains date/time values, the following metadata is provided.

Type Description
Name The column name.
Data Type The data type of the selected column.
Size The amount of memory reserved for each record in this column.
Non-Nulls The number of non-null entries in the column, including empty values.
Uniques The number of unique values in the field. Use the Unique tool to see a full count of unique and duplicate entries. See Unique Tool.
Nulls The number of values in the column that are null, excluding empty values.
Minimum The smallest value in the column.
Maximum The largest value in the column.

 

Date, Time, and DateTime

The profiling for date/time/datetime shows information such as data type, size, nulls, and min/max.

Numeric Data

If the selected column contains numeric values, the following metadata is provided.

Type Description
Name The column name.
Data Type The data type of the selected column.
Size The amount of memory reserved for each record in this column.
Non-Nulls The number of non-null entries in the column, including empty values.
Uniques The number of unique values in the field. Use the Unique tool to see a full count of unique and duplicate entries. See Unique Tool.
Nulls The number of values in the column that are null, excluding empty values.
Minimum The smallest value in the column.
Maximum The largest value in the column.
Average The average value of values in the column.
Sum The sum of values in the column.
Standard Deviation The measure of how dispersed the values are in the chart.
Variance The measure of how far a set of random numbers are dispersed from the mean.
25th Percentile The median value in the lower, or first, half of the data.
50th Percentile The median value of the data.
75th Percentile The median value in the upper, or second, half of the data.

 

Spatial Data

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.

 

String Data

If the selected column contains string values, the following metadata is provided.

Type Description
Name The column name.
Data Type The data type of the selected column.
Size The amount of memory reserved for each record in this column.
Non-Nulls The number of non-null entries in the column, including empty values.
Uniques The number of unique values in the field. Use the Unique tool to see a full count of unique and duplicate entries. See Unique Tool.
Nulls The number of values in the column that are null, excluding empty values.
Blanks The number of empty values.
Values with Leading Whitespace The number of string values with whitespace before the value. Use the Data Cleansing tool or the Formula tool trim function to resolve the problem. See Data Cleansing Tool and Formula Tool.
Values with Trailing Whitespace The number of string values with whitespace after the value.
Shortest (Non-Blank) Length The number of characters in the shortest value in the column.
Average Length The average length of values in the column.
Longest Length The number of characters in the longest value in the column.
Shortest Value The shortest value in the column.
Longest Value The longest value in the column.
First Alphanumeric Value The first string entry in a column that is sorted alphabetically.
Last Alphanumeric Value The last string entry in a column that is sorted alphabetically.

The data type of the selected column.

 

Configure the View 

Views

Depending on the type of data you are viewing, up to four tabs may display: Profile, Map, Report, and Behavior Analysis.

Two tabs can be viewed at once.

  • Single view: Click to view all tabs in a single 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.
  • Top, bottom view: Click to view all tabs in the top and bottom halves of the window. Click different tabs in each window to compare data.
New Window

Click to open data in a new, un-docked window. Data in the window will not change; this allows you to compare views and assess data after modifying and running a workflow. By default, the window name is the tool name and the tool ID of the Browse tool.

 

Rename a Window
  1. With the Browse tool selected, in the Configuration window, select Annotation.
  2. In Name, type a name for the window.

    To turn off profiling - 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.

     

View Profile Data

When a Browse tool is connected to a tool with a string, numeric, or date/time data types, the Profile tab in the Configuration window displays a chart and metadata of the selected column.

Options to view column information:

  • Select columns in the Results window to view data profile information for other columns.
Data Details

Displays the number of records, number of fields, and the file size.

Metadata

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.

Number of selected Records

Displays the number of records selected. Click to clear the selection.

View Data

See Field name, metadata, quality information, and chart profile.

View Report Data

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:

  • Fields: Click to see a list of report fields displayed in the view. Click to deselect all report fields and the to select all report fields.
  • Navigation: Click navigation arrows to view specific records. By default, the Configuration window displays 10 records at a time.
View Spatial Data

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:

  • Fields: Click to see a list of spacial object fields in the view. Click to deselect all spatial object fields and the to select all spatial object fields.
  • Pan: Click to pan around on the map by clicking and dragging the map to the desired position. Each time the pan is used, the map displays the new map image.
  • Selection: Click to select objects on the map. By selecting map objects, the corresponding data records will also become selected and indicated as being selected in the Table and Report views.

There are multiple supported selection methods. Select or click to enable, then deselect or click again to disable.

  • Single click: Selects individual objects.
  • Ctrl + click: Adds or subtracts to a selection.
  • Select and drag: Select and drag a selection box around the objects to select multiple objects at once.
  • Zoom in: Click to decrease the map area, producing a more localized map image.
  • Zoom out: Click to increase the map area, producing a more generalized map image.
  • Zoom to selection: Click to zoom to a clicked point or a selected area.
  • Reset view: Click to reset the map view to the original area.
  • Base map: Click to view and select a reference layer for the map image. Only map file and layer sets currently installed on your computer appear in the drop-down list. See Dataset Defaults.
    • Copy: Click to copy the map image to the clipboard to be pasted into other applications.
    • Export: Click to save the map image in a supported image file format: .jpeg, .png, .bmp.
View Behavior Analysis Data

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:

  • Profile: Lists profile fields in the data. Only one profile field can be viewed at a time.
  • Navigation: Click navigation arrows to view specific records. By default, the Configuration window displays 1 record at a time, because a single record contains data on all 60 clusters within the selected profile.

Dataset: Displays the data from which the profile was extracted.

Type Description
Demographic The level of classification with which the profile was built (typically household or adult).
Primary If selected, this indicates primary demographic the profile was built for (typically household, population, or adult).
Cluster Number Identifies the cluster.
Count Identifies the demographic that meets the profile criteria.
Base Identifies the demographic (household or adult) for that particular cluster.
avgVolume Identifies the average value calculated by dividing Count by Base for each cluster. Values are null if data is not provided for the cluster.
  • Data grid: Displays the cluster data.Use the Behavior Detail Fields tool to add the data available in this tab to a workflow. See Detail Fields Tool.

    Use the Behavior Detail Fields tool to add the data available in this tab to a workflow. See Detail Fields Tool. Convert a Browse tool to a Macro Output or Output Data tool. You can convert a Browse tool to a Macro Output Tool or an Output Data Tool. You can undo this change if you have enough undo levels set in your User Settings.

     

Converting to a Macro Output tool

To convert the Browse tool to a Macro Output Tool:

  1. Right-click the Browse tool in your workflow.
  2. Select Convert To Macro Output.
  3. Configure the tool.

You can now use the Browse tool as a Macro Output tool.

 

Converting to an Output Data tool


To convert the Browse tool to an Output Data Tool:

  1. Right-click the Browse tool in your workflow.
  2. Select Convert To Output Data.
  3. Configure the tool.

You can now use the Browse tool as an Output Data tool.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.