You will now import the file containing the customer data and create your first
preparation.
After logging in Talend Cloud 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
-
From the left panel menu, select Datasets to open the
list of datasets, that is also empty at that moment.
-
To import the customers.xlsx that you have
previously downloaded, you can either:
- Click the Drop a file or browse button to browse
your files and select the dataset.
- Directly drag and drop the dataset on the Talend Cloud Data Preparation screen.
The Overview tab opens, where you can see information on
your dataset.
-
Open the Configure tab on the left side of the screen.
-
In the Dataset name field, enter
Customers.
-
The Connection field is already filled in.
Because this is your first local dataset import, a Local
connection type connection will be created during the process.
This underlying connection will be used to upload all your local
datasets.
-
In the Format config section of the form, click the
Auto detect button to automatically fill the
Format information.
-
Click the View sample button to preview the first 50
rows of your dataset.
-
Click Validate to finalize the dataset
creation.
-
From the left panel menu, select Preparations and click
the Add preparation button.
-
In the Add a preparation panel that opens, select the
Customers dataset previously created.
The Preparation name field is
automatically filled but you can change the preparation name. In this example,
Customers Preparation is used.
-
Click Submit.
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.