Skip to main content
Gathering Interest

Export Previews from SQL editor to Excel, csv or similiar

Related products:Transformations and RAW
  • September 19, 2022
  • 2 replies
  • 92 views
J

Hi

At present I have access to a SQL editor in CDF.

This tool is very useful. However at present there seems to be limited option to export the result into Excel-, CSV-file  or similar. If I copy the result manually from the editor and paste this into Excel, each column is added as a new row, not a separate columns as shown in the Preview. In addtion, the column header is missing in the report file.

Here is an example of how the current result look like if I paste 2 rows with 3 columns into Excel:

1
A4MDO863J2
A4MDO863J2
FPQ-AKSO-P-XB-64020-01
2
A4MDO86IJ2
A4MDO86IJ2
FPQ-AKSO-P-XB-67010-01

Can you please see if it is possible to enable export to Excel or CSV format?

2 replies

Anita Hæhre
Seasoned Practitioner
Forum|alt.badge.img+1
  • Anita Hæhre
  • Head of Community
  • September 20, 2022
New→Gathering Interest
Anita Hæhre
S
Committed

Hi, 

Thank you for the request! 

At the moment, there is one way to do this -- you can write the results of the query to a RAW table, and then download the RAW table as a CSV. 

What are the reasons for pasting the preview results into Excel?

Mithila Jayalath
Terms & ConditionsCookie SettingsAccessibility statement