Opening a dataset from a local file - 2.3

Talend Data Preparation Getting Started Guide

author
Talend Documentation Team
EnrichVersion
6.5
2.3
EnrichProdName
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
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

You will now import the file containing the customer data and create your first preparation.

After logging in Talend Data Preparation, you are directed to the Preparations view.

This view shows all your preparations, in other words datasets on which you have started performing operations. It is empty for now, but this is where your work on the customer data will be saved. In this view, you can also add new preparations and organize them into folders.

To import the customer file containing the raw data, proceed as follows:

Before you begin

Retrieve the customers.xlsx file from the Downloads tab of the menu located in the left panel of this page.

Procedure

  1. Click the Add preparation button.
  2. In the Preparation Name field, enter the name you want to give your preparation, customers_preparation in this example.
  3. Click Import file, and select the customers.xlsx file.
  4. Click Open.

Results

Your dataset opens in the form of a preparation with an empty recipe. Your data has not been modified yet, but has been saved as a preparation on which you can start applying preparation steps.

Because you imported the customers.xlsx dataset, and created the corresponding preparation using the Add preparation button, every change made to customers_preparation will be automatically saved. As for the raw dataset you imported, it can be viewed in the Datasets view, and the data remains unchanged.