Changing the semantic type - 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 can change the semantic type of your data to make sure that the data type of your column matches the actual values.

Talend Data Preparation automatically suggests a semantic type for your data. This type is specified under the header of each column. You can see in the ZIP column that because they have the same number of digits, the US zip codes have been mistaken for French ones. You will now set the semantic type of the column to US postal code.

To modify the semantic type of a column, proceed as follows:

Procedure

  1. Click the options icon in the header of the ZIP column.
  2. In the drop-down menu, point your mouse over this column is a fr_postal_code.

    A list of suggested semantic types opens.

  3. Click US Postal Code

Results

The semantic type of the ZIP column has now been set to us_postal_code.

More generally, if the semantic type proposed by Talend Data Preparation for one column is not the desired one, you can change it at any time, based on your own experience.