# Viewing the data analyzed against patterns
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
## Before you begin
You have installed in Talend Studio the SQL explorer libraries that are required for data quality.
## About this task
When you add one or more patterns to an analyzed column, you check all existing data in the column against the specified patterns. After the execution of the column analysis, using the Java or the SQL engine you can access a list of all the valid/invalid data in the analyzed column.
When you use the Java engine to run the analysis, the view of the actual data will open in the Profiling perspective. While if you use the SQL engine to execute the analysis, the view of the actual data will open in the Data Explorer perspective.
If you do not install these libraries, the Data Explorer perspective will be missing from Talend Studio and many features will not be available. For further information about identifying and installing external modules, see [Installing external modules to Talend Studio](https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/installing-external-modules).
To view the actual data in the column analyzed against a specific pattern, do the following:
## Procedure
1. Follow the steps outlined in [Defining the columns to be analyzed](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/defining-columns-to-be-analyzed) and [Adding a regular expression or an SQL pattern to a column analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/adding-regular-expression-or-sql-pattern-to-column-analysis) to create a column analysis that uses a pattern.
2. Execute the column analysis.
The editor switches to the Analysis Results view.
3. Browse to Pattern Matching under the name of the analyzed column.
The generated graphic for the pattern matching is displayed accompanied with a table that details the matching results.
4. Right-click the pattern line in the Pattern Matching table and select an option.
| Option | Results |
| --- | --- |
| View valid/invalid
values | open a view of all valid/invalid values measured against
the pattern used on the selected column |
| View valid/invalid
rows | open a view of all valid/invalid rows measured against
the pattern used on the selected column |
| Generate Jobs | generate ready-to-use Jobs that will recuperate
valid/invalid rows or both types of rows in the selected
column and write them in output files or databases.
For
more information, see [Recuperating matching and non-matching rows](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/recuperating-matching-and-non-matching-rows) |
## Results
When using the SQL engine, the view opens in the Data Explorer perspective listing valid/invalid rows or values of the analyzed data according to the limits set in the data explorer.
This explorer view will also give some basic information about the analysis itself. Such information is of great help when working with multiple analysis at the same time.
The data explorer does not support connections which has empty user name, such as Single sign-on of MS SQL Server. If you analyze data using such connection and you try to view data rows and values in the Data Explorer perspective, a warning message prompt you to set your connection credentials to the SQL Server.
When using the Java engine, the view opens in the Profiling perspective listing the number of valid/invalid data according to the row limit you set in the Analysis parameters view of the analysis editor. 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).
You can save the executed query and list it under the Libraries > Source Files folders in the DQ Repository tree view if you click the save icon on the SQL editor toolbar. For more information, see [Saving the queries executed on indicators](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/saving-queries-executed-on-indicators).