# Creating analyses from table or column names

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

## About this task

You can use simplified ways to create one or multiple column analyses. All what you need to do is to start from the table name or the column name under the relevant DB Connection folder in the DQ repository tree view.

The options from the table name are different from the options from the column name.

## Procedure

1. To create a column analysis directly from the relevant table name in the DB Connection, do the following:
   1. In the DQ repository tree view, expand Metadata > DB Connections.
   2. Browse to the table that holds the columns you want to analyze and right-click it.
   3. From the context menu, select a type of analysis.
      * Match Analysis: open the match analysis editor where you can define match rules and select the columns on which you want to use the match rules.

        For more information see [Analyzing duplicates](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/dq-analyzing-duplicates).

      * Table Analysis: analyze the selected table using SQL business rules.

        For more information on the Simple indicators, see [Simple](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/simple-statistics).

      * Column Analysis: analyze all the columns included in the selected table using the Simple indicators.

        For more information on the Simple indicators, see [Simple](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/simple-statistics).

      * Pattern Frequency Analysis: analyze all the columns included in the selected table using the Pattern Frequency along with the Row Count and the Null Count indicators.

        For more information, see [Pattern frequency](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/pattern-frequency-statistics).

   These steps replace the procedures outlined in [Defining the columns to be analyzed](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/defining-columns-to-be-analyzed "The first step in analyzing the content of one or multiple columns is to define the columns to be analyzed. The analysis results provides statistics about the values within each column."). You can proceed following the steps outlined in [Finalizing and executing the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/finalizing-and-executing-column-analysis).
2. To create a column analysis directly from the column name in the DB Connection, do the following:
   1. In the DQ repository tree view, expand Metadata > DB Connections.
   2. Browse to the columns you want to analyze and right-click them.
   3. From the context menu, select an action to perform or Column Analysis:
      * Analyze: create an analysis for the selected column. You must later set the indicators you want to use to analyze the selected column.

        For more information on setting indicators, see [Setting indicators on columns](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/setting-indicators-on-columns). For more information on accomplishing the column analysis, see [Finalizing and executing the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/finalizing-and-executing-column-analysis).

      * Nominal value analysis: create a column analysis on nominal data preconfigured with indicators appropriate for nominal data, namely Value Frequency, Simple and Text indicators.

      * Simple analysis: analyze the selected column using the Simple indicators.

        For more information on the Simple indicators, see [Simple](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/simple-statistics).

      * Pattern frequency analysis: analyze the selected column using the Pattern Frequency along with the Row Count and the Null Count indicators.

        For more information on the Pattern Frequency Statistics, see [Pattern frequency statistics](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/pattern-frequency-statistics).

      * Analyze Column Set: perform an analysis on the content of a set of columns. This analysis focuses on a column set (full records) and not on separate columns as it is the case with the column analysis.

        For more information, see [Creating a simple table analysis (Column Set Analysis)](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-simple-table-analysis-column-set-analysis).

      * Analyze Correlation: perform column correlation analyses between nominal and interval columns or nominal and date columns in database tables.

        For more information, see [Numerical correlation analyses](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/numerical-correlation-analyses).

      * Analyze matches: open the match analysis editor where you can define match rules and select the columns on which you want to use the match rules.

        For more information see [Analyzing duplicates](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/dq-analyzing-duplicates).

   These steps replace one of or both of the procedures outlined in [Defining the columns to be analyzed](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-09/defining-columns-to-be-analyzed "The first step in analyzing the content of one or multiple columns is to define the columns to be analyzed. The analysis results provides statistics about the values within each column."). You can proceed following the same steps outlined in [Finalizing and executing the column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/finalizing-and-executing-column-analysis).