# Creating a column analysis

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
* Qlik Cloud Enterprise Edition
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

This procedure describes the first steps for creating a column analysis.

You can find more details on the next steps in:

* The [Creating a basic analysis on a database column](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-basic-analysis-on-database-column) section that explains the procedures to analyze the content of one or multiple columns in a database.
* The [Creating a basic column analysis on a file](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-basic-column-analysis-on-file) section that explains the procedures to analyze columns in delimited files.

## Procedure

1. In the DQ Repository tree view, expand Data Profiling.
2. Right-click the Analysis folder and select New Analysis.
3. From the Column Analysis folder, select an option:
   | Option | Results |
   | --- | --- |
   | Basic Column Analysis | generate an empty column analysis where you can select the<br>columns to analyze and manually assign the indicators on each<br>column.<br><br>For more information, see [Creating a basic analysis on a database<br>column](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-basic-analysis-on-database-column). |
   | Discrete Data Analysis | create a column analysis on numerical data preconfigured<br>with the Bin Frequency and simple<br>statistics indicators. You can then configure further the<br>analysis or modify it in order to convert continuous data into<br>discrete bins (ranges) according to your needs.<br><br>For more<br>information, see [Analyzing discrete data](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/analyzing-discrete-data). |
   | Nominal Values Analysis | create a column analysis on nominal data preconfigured with<br>indicators appropriate for nominal data, namely Value<br>Frequency, Simple<br>Statistics and Text<br>Statistics indicators.<br><br>For example results<br>about these statistics, see [Finalizing and executing the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/finalizing-and-executing-column-analysis). |
   | Pattern Frequency Analysis | create a column analysis preconfigured with the<br>Pattern Frequency, Pattern<br>Low Frequency and the row and null count<br>indicators.<br><br>This analysis can learn about patterns in your<br>data. It shows frequent patterns and rare patterns so that<br>you can identify quality issues more easily.<br><br>For example results about these statistics, see [Finalizing and executing the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/finalizing-and-executing-column-analysis). |
   | Semantic Discovery Analysis | create a column analysis preconfigured with indicators and<br>patterns that best suite data after exploring the semantic<br>categories of data columns and using related concepts from the<br>semantic repository.<br><br>For more information, see [Semantic-aware<br>analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-10/semantic-aware-analysis). |
   | Summary Statistics Analysis | create a column analysis on numerical data preconfigured with the<br>Summary Statistics and the row and null<br>count indicators.<br><br>This helps you to get a good idea of the shape of<br>your numeric data by computing the range, the inter quartile range<br>and the mean and median values.<br><br>For an example of the use of Summary Statistics, see [Setting system or user-defined indicators](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-10/setting-indicators-on-columns) and [Finalizing and executing the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/finalizing-and-executing-column-analysis). |
4. Usually, the sequence of profiling data in one or multiple columns involves the following steps:
   1. Connecting to the data source. For more information, see [Creating connections to data sources](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-connections-to-data-sources).
   2. Defining one or more columns on which to carry out data profiling processes.

      It will define the content, structure, and quality of the data included in the columns.
   3. Setting predefined system indicators or indicators defined by the user on the columns that need to be analyzed or monitored.

      These indicators will represent the results achieved through the implementation of different patterns.
   4. Adding to the column analyses the patterns against which you can define the content, structure, and quality of the data.

      For more information, see [Adding a regular expression or an SQL pattern to a column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-10/using-regular-expressions-and-sql-patterns-in-column-analysis "You can add to any column analysis one or more regular expressions or SQL patterns against which you can match the content of the column to be analyzed.").
   5. Generating reports from these analyses and sharing the results among team members.

      These reports let you compare current and historical statistics to determine the improvement or degradation of data. For more information, see [Reports](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/reports).

## What to do next

The [Creating a basic analysis on a database column](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-basic-analysis-on-database-column) section explains the procedures to analyze the content of one or multiple columns in a database.

The [Creating a basic column analysis on a file](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-basic-column-analysis-on-file) section explains the procedures to analyze columns in delimited files.

Talend Studio provides you with lock modes that allow you, if you are the first user to open an item, to lock that item and thus have the "read and write" rights. All other users who try to open the same item simultaneously will have a read-only access. For more information, see [Lock principle](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/lock-principle).