Profile Guide

10.5.1
- 10.5.6
- 10.5.2
- 10.5
- 10.4.0

Back Next

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.

In the

Library

workspace, select the project or folder that contains the profile.

Click the profile to open it.

The profile results appears in summary view.

In the summary view, click

Actions

Export Data

The

Export data to a file

dialog box appears.

In the

Export data to a file

dialog box, enter a file name. Optionally, use the default file name.

Select

All (Summary, Values, Patterns, Statistics, Properties)

Data doman discovery results

, and select a

Code Page

. Click

The data is exported to a Microsoft Excel spreadsheet.

Click a column in the summary view.

The column results appear in detailed view.

In the detailed view, click

Actions

Export Data

The

Export data to a file

dialog box appears.

In the

Export data to a file

dialog box, enter a file name. Optionally, use the default file name.

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.

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.

Rename Saved Search

Table of Contents

Profile Guide

Profile Guide

Exporting Profile Results from Informatica Analyst

Exporting Profile Results from Informatica Analyst