Exporting Data
This document explains how to export data from Astera Dataprep using different output formats. You can choose between Excel, Delimited File, and Log File.
Each method can be done through the toolbar or by simply asking in Chat.
Suppose you have a Dataprep Recipe containing cleansed data that you want to save as an Excel file for reporting purposes.
Open your Dataprep Recipe.

In the toolbar, click Write and select Excel from the drop-down.

This opens Recipe Configuration – Write Excel panel.

In this panel, you can configure the following options:
File Path: Specify the file path (and name) for the output file. You can type the path directly or click the folder icon to browse.
Worksheet: Specify the name of your worksheet. This can be used to either overwrite data in an existing worksheet or to add a new worksheet.
Start Address: Indicate the cell value from where you want Astera Dataprep to start writing the data.
Click
Apply to save settings or
Cancel to discard.

Click Execute Dataprep Recipe to generate the Excel file.

Alternatively, you can ask in Chat to write to an Excel file and then later instruct it to execute the recipe.

Last updated
Was this helpful?