Exporting Query Results

In addition to the ability to execute a query directly to a file, you can also export query results to CSV or TSV file format.

Exporting results to CSV

Once you have successfully executed a query you can elect to export those results in Comma Separated Value (CSV) format to a file outside of Aginity Pro. To do this, right-click anywhere in the results panel. Doing this will display a context menu from which you will select the option “Export to CSV”.

mceclip2.png

After selecting this option, you will be presented with a screen that permits you to select the location to which to save your results. Once you have identified the proper location, press the Save button to complete the export.

CSV files may subsequently be imported into a large number of different programs for further review and analysis.

 

Exporting results to TSV

A tab-separated values file is a simple text format for storing data in a tabular structure, e.g., database table or spreadsheet data, and a way of exchanging information between databases. Each record in the table is one line of the text file.
mceclip1.png
 
Premium and Enterprise users will find an additional option to export to Excel.
Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments

1 comment
  • When you try to save/export to csv. In the save as option it only displays all files. You will have to manually add .csv to the end of your file. Very disappointed with the feature it is practically useless 

    0

Please sign in to leave a comment.