# Creating a basic analysis on a database column

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Real-Time Big Data Platform

## 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](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/using-java-or-sql-engine).

Information noteNote: When you use the Java engine to run a column analysis on big sets or on data with many problems, it is advisable to define a maximum memory size threshold in Talend Studio Preferences to execute the analysis as you may end up with a Java heap error.

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](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/analyzing-tables-in-databases).

The sequence of creating a basic column analysis involves the following steps:

## Procedure

1. Defining the columns to be analyzed.
2. Setting predefined system indicators or indicators defined by the user for the column(s).
3. Adding the patterns against which to define the content, structure and quality of the data.

### In this section

* [Defining the columns to be analyzed and setting indicators](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/defining-columns-to-be-analyzed-and-setting-indicators)
* [Finalizing and executing the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/finalizing-and-executing-column-analysis)
* [Using the Java or the SQL engine](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/using-java-or-sql-engine)
* [Accessing the detailed view of the database column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/accessing-detailed-view-of-database-column-analysis)
* [Viewing and exporting analyzed data](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/viewing-and-exporting-analyzed-data)
* [Using regular expressions and SQL patterns in a column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/using-regular-expressions-and-sql-patterns-in-column-analysis)
* [Saving the queries executed on indicators](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/saving-queries-executed-on-indicators)
* [Identifying duplicate values in a column](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/identifying-duplicate-values-in-column)
* [Standardizing phone numbers](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/standardizing-phone-numbers)
* [Extracting distinct values](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/extracting-distinct-values)
* [Creating analyses from table or column names](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/creating-analyses-from-table-or-column-names)