Changing the semantic type - Cloud

Talend Cloud Data Preparation Getting Started Guide

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2024-03-05

You can change the semantic type of your data to make sure that the data type of your column matches the actual values.

Talend Cloud 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.

Zip column with FR Postal Code as the semantic type.

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

Procedure

  1. Click the options icon in the header of the Zip column.
    Options icon with the expanded menu.
  2. In the menu, click Column is a FR Postal Code.
    FR Postal Code is selected.

    A list of suggested semantic types opens.

  3. Click US Postal Code.

Results

The semantic type of the Zip column is now set to US Postal Code.
US Postal Code is set.

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