Skip to main content
Hi, in data extraction and transformation we have created a temporary table. In order to check whether the records are correct, we did not drop the table. How could we export the records of that table to Excel (so that we can do some checks)? Thanks!

Hi Manuel,

 

You have to load a data model with this table and create an analysis with this data model. In the analysis, you have to activate the export in "Analysis settings"-"General settings" with the button that shows the following text "Allow excel and csv export of analysis components". Later with right button you can download the data in excel or csv.

 

https://docs.celonis.com/en/export.html

 

Regards


Hi Manuel,

 

in addition to that:

You can use the OLAP Table element in your analysis to add specific fields/columns to the export.

But the step "loading the table in a data model and creating an analysis" is necessary.


Thank you, Gentlemen! Both approaches help. I was investigating the wrong place, then: I looked at the Data Exploration report where I can display all records of the table, but this feature apparently does not allow to directly export the records:

grafik


Reply