Blending data
The Lookup feature allows you to take data from an existing dataset and add it to your preparation.
This example assumes that:
- You have downloaded the following folder and extracted the file: states.zip.
- You have added states.csv to your list of datasets in Talend Data Preparation. For more information about how to import a dataset, see Opening a dataset from a local file.
In this example, you want to add more geographical information on your customers, thanks to a reference file that you possess: the States dataset. This dataset contains the list of the US State codes, and their corresponding region. You will dynamically use the data from this dataset to complement your preparation. This will allow you to add information about each customer's subscription region, based on their State code.
To blend the data from another dataset in your preparation, proceed as follows:
Procedure
-
Click the Lookup icon in the upper part of the
screen.
The Add data from lookup panel opens at the bottom of the screen.
-
Select the State column in both your preparation and the
dataset, so that they appear in blue.
Your preparation and the dataset can only be linked together if they have a column with information in common, the US State codes in this case.
-
In the States dataset,
select the Add to Dataset check box under
the Region column header to add it to
your current preparation.
-
Point your mouse over the Confirm button to preview the
changes.
