Versions Compared

Old Version 3

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 4

changes.mady.by.user Wara Hermosa

Saved on

Key

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

...

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 Modified 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

  • Click Image Modified or click the down arrow next to the icon ( Image Modified ) and click Preview in Excel.

Image Modified

Export to Excel

...

  1. On the Dimension pane, click . 
  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 .
  3. In the View Data window, click the down arrow next to the icon () and then Export to Excel.
    Image Modified
  4. Specify the export settings.
    Image Modified
    • 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 Modified

Export to CSV

...

  1. On the Dimension pane, click Image Modified. 
  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 .
  3. In the View Data window, click the down arrow next to the icon () and then Export to CSV.
    Image Modified
  4. Specify export settings.
    Image Modified
    • 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.

...