Basic Data Profile Tool

The Basic Data Profile tool analyzes data and provides metadata for each column (field) of data.

Use the Basic Data Profile tool to see an overview, or profile, of data and output the information for further analysis. To see a visual representation of the data profile, in addition to metadata, use a Browse tool. See Browse Tool.

Configure the tool

Complete any of the optional configuration options:

  • Limit for Exact Count: The default limit is recommended for best performance. Increase the limit to see profile information for more data. Type or click to select the maximum number of unique values that you want Alteryx to identify in the data.
  • Size Limit to Return All Unique Values (Characters): The default limit is recommended for best performance. Increase the limit to see profile information for more data. Type or click to select the maximum number of characters you want Alteryx to check in a value to determine if the value is unique.
  • Use Metric Units: Select to use metric units of measure. This option only applies to spatial data.

View the output

Depending on the type of data from the connect tool, the data profile information in the Results window varies. See Data Types, for a list of data types.

Results are listed vertically. Scroll to see the metadata for each column in the data.