Column Profile Export Files in Informatica Analyst
You can export column profile results to a CSV file or a Microsoft Excel file based on whether you choose a part of the profile results or the complete results summary.
You can export value frequencies, pattern frequencies, datatypes, or drilldown data to a CSV file for selected values and patterns. You can export the profiling results summary for all columns to a Microsoft Excel file. Use the Data Integration Service privilege Drilldown and Export Results to determine, by user or group, who exports profile results.
Profile Export Results in a CSV File
You can export value frequencies, pattern frequencies, datatypes, or drilldown data to view the data in a file. The Analyst tool saves the information in a CSV file.
When you export inferred column patterns, the Analyst tool exports a different format of the column pattern. For example, when you export the inferred column pattern X(5), the Analyst tool displays the following format of the column pattern in the CSV file: XXXXX.
Profile Export Results in Microsoft Excel
When you export the complete profile results summary, the Analyst tool saves the information to multiple worksheets in a Microsoft Excel file. The Analyst tool saves the file in the "xlsx" format.
The following table describes the information that appears on each worksheet in the export file:
Tab | Description |
|---|
Column Profile | Summary information exported from the Column Profiling view after the profile runs. Examples are column names, rule names, number of unique values, number of null values, inferred datatypes, and date and time of the last profile run. |
Values | Values for the columns and rules and the frequency in which the values appear for each column. |
Patterns | Value patterns for the columns and rules you ran the profile on and the frequency in which the patterns appear. |
Data Types | All the datatypes for the column, frequency of each datatype, percentage value, and status of the datatype, such as Inferred, Approved, or Rejected. |
Statistics | Statistics about each column and rule. Examples are average, length, top values, bottom values, and standard deviation. |
Properties | Properties view information, including profile name, type, sampling policy, and row count. |
Exporting Profile Results from Informatica Analyst
You can export the results of a profile to a ".csv" or ".xlsx" file to view the data in a file.
1. In the Navigator, select the project or folder that contains the profile.
2. Click the profile to open it.
The profile opens in a tab.
3. In the Column Profiling view, select the column that you want to export.
4. Click Actions > Export Data.
The Export Data to a file window appears.
5. Enter the file name. Optionally, use the default file name.
6. Select the type of data to export.
- - All (Summary, Values, Patterns, Statistics, Properties)
- - Value frequencies for the selected column.
- - Pattern frequencies for the selected column.
- - Drilldown data for the selected values or patterns.
7. Enter a file format. The format is Excel for the All option and CSV for the rest of the options.
8. Select the code page of the file.
9. Click OK.