Exporting a preparation made on a database dataset - 8.0

Talend Data Preparation User Guide

Version
8.0
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
When you are finished preparing a dataset extracted from a database, you may want to export your data.

Procedure

  1. Click the Export button in the application header bar.
  2. If the result of your preparation is larger than your current sample size, 10 000 rows by default, select an export option:
    • If you select Current sample, only the sample you have been working on will be exported.
    • If you select All data, all the preparations steps you have performed on your sample will be applied to the rest of the dataset as well.
  3. Choose the file format you want to use when exporting your data:
    • If you choose Local CSV file, select which field delimiter, text enclosure and escape characters to use and enter a name for the file to export.
    • If you choose Local XLSX file, or Local Tableau file choose a name for the file to export.
    • If you choose Amazon S3, enter your credentials and other information to store your file on Amazon S3.
  4. Click Confirm.

Results

In the case of an export to a local file, if you chose to export only the Current sample, the download automatically starts. But if you selected All data to export the entire data, the export process is launched in the background. You can check the status of the export, and download your output file in the Export history page. For more information, see The export history page.

The export process triggers a refresh in the data that is fetched from the database, guaranteeing that the data displayed in the output is always up to date.

However, due to this refresh, it is possible that a dataset originally smaller than 10,000 rows, now exceeds this limit. In this case, if you export to a local file, only the sample is kept.