You can export the profile results to a Microsoft Excel file based on whether you choose a part of the profile results or the complete results summary.
You can export the profile results for any valid profile run. When you export the profile results for a profile run, Data Profiling saves the file name with the latest name of the profile. To export the profile results, verify that you have the enabled the Export Data Profiling Results feature for the user role in the Administrator.
Example
You are a data analyst and you have access to create and run profiles using the Data Profiling service. The sales team need the profile results for the Sales table to make some business decisions and they do not have access to Data Profiling.
To accomplish this task, you can create a profile on the Sales table, run the profile, and export the results to a Microsoft Excel file. You can share the file with the sales team.
Exporting profile results to a file
You can export the results for one or more columns or for all columns.
1Open a profile to view the Results tab.
2Click Actions > Export Profile Results.
3In the Export Profile Results to a File dialog box, enter the following details:
- File Name. You can retain the default file name, or enter a file name of your choice.
- Choose All Columns to export the results for all the columns, or choose Selected Columns and select one or more columns to export the results for the chosen columns.
- Choose one or more of the following options:
▪ Summary. Exports all the profile results.
▪ Value Frequency. Exports only the value frequencies.
▪ Statistics. Exports only the statistics.
▪ Patterns. Exports only the patterns.
▪ Data Types. Exports only the data types, which include documented and inferred data types.
By default, the File Format is set to Excel and the Code Page is set to 7-bit ASCII.
4Click Export.
You can open or save the file to your local machine.
View exported profile results in the file
When you export the profile results, the profile results are exported to a Microsoft Excel file. The service saves the file in the ".xlsx" format.
The following table describes the information that appears in each worksheet in the export file:
Worksheet
Description
Column Profile
Summary of profile results appears in this worksheet where the results for columns and rules appear in collapsible panes.
You can view the following results in the worksheet:
- Profile name
- Filter name
- Sampling policy
- Column name and its statistics appear in separate rows.
- Rule and its statistics appear in separate rows.
Values
Contains values in a column with the value frequency, percentage, and maximum length.
This worksheet appears when you choose the Value Frequency option in the Export Profile Results to a File dialog box.
Statistics
Contains the following statistics for each column:
- Maximum Length
- Minimum Length
- Bottom (5)
- Top (5)
This worksheet appears when you choose the Statistics option in the Export Profile Results to a File dialog box.
Patterns
Contains inferred patterns and their frequency and percentage for each column.
This worksheet appears when you choose the Patterns option in the Export Profile Results to a File dialog box.
Data Types
Contains inferred data types and their frequency and percentage for each column.
This worksheet appears when you choose the Data Types option in the Export Profile Results to a File dialog box.
Properties
Contains the following profile and profile run properties: