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, data types, 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, data types, 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 summary view after the profile runs. Examples are column names, rule names, number of distinct values, number of null values, inferred data types, 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 data types for the column, frequency of each data type, percentage value, and status of the data type, 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 Library workspace, select the project or folder that contains the profile.
2. Click the profile to open it.
The profile results appears in summary view.
3. In the summary view, click Actions > Export Data.
The Export data to a file dialog box appears.
4. In the Export data to a file dialog box, enter a file name. Optionally, use the default file name.
5. Select All (Summary, Values, Patterns, Statistics, Properties) or Data doman discovery results, and select a Code Page. Click OK.
The data is exported to a Microsoft Excel spreadsheet.
6. Click a column in the summary view.
The column results appear in detailed view.
7. In the detailed view, click Actions > Export Data.
The Export data to a file dialog box appears.
8. In the Export data to a file dialog box, enter a file name. Optionally, use the default file name.
9. Select one of the following options:
- - All (Summary, Values, Patterns, Statistics, Properties)
- - Value frequencies for the selected column.
- - Pattern frequencies for the selected column.
- - Data types for the selected column.
- - Drilldown data for the selected values.
- - Drilldown data for the selected patterns.
- - Drilldown data for the selected data types.
10. Enter a file format. The format is Excel for the All option and CSV for the rest of the options. You can choose to export the field name as a first row in the file.
11. Select the code page of the file.
12. Click OK.
The data is exported to the file.