About this task
You can build your analysis from scratch, analyze the content of one or multiple columns and execute the created analyses using the Java or the SQL engine. This type of analysis provides statistics about the values within each column.
When you use the Java engine to run a column analysis, you can view the analyzed data according to parameters you set yourself. For more information, see Using the Java or the SQL engine.
You can also analyze a set of columns. This type of analysis provides statistics on the values across all the data set (full records). For more information, see Analyzing tables in databases.
You can also generate a Job that removes duplicate values from a specific analyzed column. For more information on removing duplicate values, see Generating a Job to Identify duplicate values in an analyzed column.
The sequence of creating a basic column analysis involves the following steps:
Defining the column(s) to be analyzed.
For more information, see Defining the columns to be analyzed.
- Setting predefined system indicators or indicators defined by the user for the column(s).
Adding the patterns against which to define the content, structure and quality of
For more information, see Using regular expressions and SQL patterns in a column analysis.
For more information on pattern types and management, see Patterns.