# Viewing and exporting analyzed data

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

## Before you begin

* You have selected the Profiling perspective.
* A column analysis has been created and executed.

## About this task

After running your analysis:

* Using the SQL or the Java engine and from the analysis results, you can right-click any of the rows in the statistic result tables and access a view of the actual data.
* Using the Java engine, you can use the analysis results to access a view of the actual data.
* Using the SQL engine, you can use the analysis results to open the Data Explorer perspective and access a view of the actual data.

![Contextual menu of analyzed data in the Simple section.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/Column_Analysis_JavaEngine1.png)

## Procedure

1. Right-click a data row in the statistic results of any of the analyzed columns and select an option as the following:
   | Option | Operation |
   | --- | --- |
   | View rows | Open a view on a list of all data rows in the analyzed column.<br><br>Information noteNote: For the Duplicate Count indicator, the<br>View rows option will list all the rows that are<br>duplicated. So if the duplicate count is 12 for example, this option will list 24 rows. |
   | View values | Open a view on a list of the actual data values of the analyzed column. |
   | Identify duplicates | Generate a ready-to-use Job that identifies and separates<br>unique and duplicate records in the selected column for<br>subsequent processing. This Job outputs all the<br>duplicates in a reject CSV file by default, and writes<br>the unique values in another separate file. For further<br>information, see [Generating a Job to Identify duplicate values in an analyzed column](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/generating-job-to-identify-duplicate-values-in-analyzed-column). |

   Options other than the above listed ones are available when using regular expressions and SQL patterns in a column analysis.

   When using the SQL engine, the view opens in the Data Explorer perspective listing the rows or the values of the analyzed data according to the limits set in the data explorer.

   If the Data Explorer perspective is missing from Talend Studio, you must install certain SQL explorer libraries that are required for data quality to work correctly, otherwise you may get an error message.

   For further information about identifying and installing external modules, see [Installing external modules to Talend Studio](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/installing-external-modules).

   ![Example of a query and the rows returned against this query.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/Column_Analysis_SQLEngine.png)

   Information noteWarning: 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 Talend Studio listing the number of the analyzed data rows you set in the Analysis parameters view of the analysis editor.

   ![Overview of the View rows tab.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/Column_Analysis_JavaEngine2.png)
2. From this view, you can export the analyzed data into a CSV file:
   1. Click ![Export to .csv](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/export_icon.png) in the upper left corner of the view.
   2. A dialog box opens.

      ![Overview of the CSV export options dialog box.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/Export_Analyzed_Data1.png)
   3. Click Choose... and browse to where you want to store the CSV file and give it a name.
   4. Click OK to close the dialog box.

      A CSV file is created in the specified place holding all the analyzed data rows listed in the view.