Versions Compared

Old Version 2

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version 3

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Visual Analytics offers you with the ability to export the the summarized or underlying data of a dataset or data of a view into a CSV file or an Excel workbook, via the View Data window.

Image Modified

Preview in Excel

If you want to quickly review the data in Excel and then discard it, you can use the Preview in Excel feature. On clicking Image RemovedImage Added or Preview in Excel option, Visual Analytics opens an Excel file containing the data and saves the file in your system's temporary directory. On closing Aqua Data Studio, the temporary Excel file is deleted from your system.
 
To preview your data

Image RemovedImage Added

Export to Excel

...

  1. On the Dimension pane, click Image Removed Image Added. 
  2. Alternatively, if you want to export summarized or underlying data of a particular data point, then hover your mouse on a data point, and then on the tooltip, click Image Removedclick Image Added.
  3. In the View Data window, click the down arrow next to the icon (Image RemovedImage Added) and then Export to Excel.
    Image RemovedImage Added
  4. Specify the export settings.
    Image RemovedImage Added
    • Choose to export the column headers and row count.
    • Choose to replace blank cells representing NULL data by "(null)" text. 
    • Choose to open the exported worksheet immediately after the export process completes.
  5. Click Next, then browse and select a folder where you want to export the worksheet, type a name for the exported Excel file, and then click Export.
Info

You can also export selected records to Excel. The process of exporting selected records is the same as exporting complete view data. When in the View Data window, select the records you want to export to Excel. The Export to Excel dialog will display a message about highlighted cells exporting. 
Image RemovedImage Added

Export to CSV


The Export to CSV exports data in a comma-separated value (CSV) file. By default, Visual Analytics uses the comma delimiter to separate each cell of a row in the exported CSV file and saves the file with .csv extension. If you use any other delimiter, you can save the file with a .txt extension.
 
To export view data to CSV 

  1. On the Dimension pane, click Image Removed Image Added. 
  2. Alternatively, if you want to export summarized or underlying data of a particular data point, then hover your mouse on a data point, and then on the tooltip, click Image Removed Image Added.
  3. In the View Data window, click the down arrow next to the icon (Image RemovedImage Added) and then Export to CSV.
    Image RemovedImage Added
  4. Specify export settings.
    Image RemovedImage Added
    • Choose a delimiter to separate the values in each row. 
    • Choose a string and date quoted identifier. The string and date quoted identifiers add quotes to string and date type values.
    • Choose an encoding and platform into which the file will be saved.
    • Choose to export the column headers and row count.
    • Choose to replace blank cells representing NULL data by "null" text. 
    • Choose to open the exported file immediately after the export process completes.
  5. Click Next, then browse and select a folder where you want to export the file, type a name for the exported CSV file, and then click Export.

...