Table of Contents

Search

  1. Preface
  2. Data Profiling
  3. Profiles
  4. Profile results
  5. Tuning data profiling task performance
  6. Troubleshooting

Data Profiling

Data Profiling

Exporting profile results to a file

Exporting profile results to a file

You can export the results for one or more columns or for all columns.
  1. Open a profile to view the
    Results
    tab.
  2. Click
    Actions
    Export Profile Results
    .
  3. In 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
    .
  4. Click
    Export
    .
    You can open or save the file to your local machine.

0 COMMENTS

We’d like to hear from you!