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.
Suppose you have a Dataprep Recipe containing cleansed data that you want to save as a CSV file for sharing.
Open your Dataprep Recipe.
In the toolbar, click Write and select Delimited File from the drop-down.
This opens the Recipe Configuration – Write Delimited panel.
In this panel, you can configure the following options:
Append To File (If Exists): Choose whether to append new entries or overwrite the file.
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.
Field Delimiter: Allows you to select a delimiter from the drop-down list for the fields.
Record Delimiter: Allows you to select the delimiter for the records in the fields. The choices available are carriage-return and line-feed combination, carriage-return and line-feed. You can also type the record delimiter of your choice instead of choosing the available options.
Click
Apply to save settings or Cancel to discard.Click Execute Dataprep Recipe to generate the file.
Alternatively, you can ask in Chat to write to a delimited file and then later instruct it to execute the recipe.
Suppose you have a Dataprep Recipe processing customer transaction and you want to log specific records for tracking or debugging.
Open your Dataprep Recipe.
In the toolbar, click Write and select Log File from the drop-down.
This opens the Recipe Configuration – Log 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.
Create a new file on each run: Check this box if you want a separate log file generated every time the recipe runs.
Log Level Type: Select which log entries to include:
All: Logs all messages.
Errors: Logs only error messages.
Warnings: Logs only warnings.
Error and Warnings: Logs both errors and warnings.
Stop Logging After: Specify the number of records after which logging should stop.
Click
Apply to save settings or Cancel to discard.Click Execute Dataprep Recipe to generate the file.
Alternatively, you can ask in Chat to write to a log file and then later instruct it to execute the recipe.
Last updated
Was this helpful?