Exporting data

If you discover insights as you analyze your data, you can export the data to share with others or analyze further in another business insights tool, for example.

You can export your data as a CSV file or you can generate a separate JSON file for each record.

IBM Cloud Pak for Data For IBM Cloud Pak for Data only, you cannot export secured collections. For more information, see Supporting document-level security.

To export your data, complete the following steps:

On the initial search page, submit a search to find the documents of interest.
On the search results page in guided mode, click Show documents to open the Documents view, and then click the Export icon in the toolbar.
Complete the appropriate steps for the format in which you want to export the data.
- If you want to export the data in JSON format, complete the following steps:
  1. Choose Export JSON to generate one JSON file for each record.
  2. Optional: You can change the following values:
    - Name. The file is named export_document_{today's_date} by default.
    - Encoding. UTF-8 is used by default.
    - Choose whether to include fields and facets. They are excluded by default.
- If you want to export the data in CSV format, complete the following steps:
  1. Optional: To customize the CSV output, choose Export CSV with advanced options.
    
    You can define the format of the following elements:
    - Text content field: This is the main body field (or fields, if you configured more than one field with analyzable text). You can choose to exclude it from the export. It is exported as a column for a fact table by default.
    - All other fields: You can choose to export them as columns for fact tables or export them as dimension tables. They are excluded from the export by default.
    - Facets: You can choose to export the facets as separate CSV files that can be used as dimension tables. They are excluded from the export by default.
    After customizing the CSV format, click Save, and then click the Export icon from the toolbar again.
    
    If you use the same web browser to export data in CSV format again later, your saved settings are applied automatically.
  2. Choose Export CSV.
  3. Optional: You can change the following values:
    - Name. The file is named export_document_{today's_date} by default.
    - Encoding. UTF-8 is used by default.
    - Date and time format. Unix epoch time is used by default.
Click Export.