Predefined Semantic Types

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
6.3
2.0
EnrichProdName
Talend Data Preparation
Talend Real-Time Big Data Platform
Talend Big Data
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend ESB
Talend Data Fabric
Talend Data Integration
Talend Big Data Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

When you add a dataset, Talend Data Preparation automatically suggests one of the supported semantic types for each column.

The table below lists all the supported semantic types.

Semantic type

Description

ADDRESS_LINE

Street number and name

AIRPORT

Airport

AIRPORT_CODE

Airport code

ANIMAL

Animal

AT_VAT_NUMBER

Austrian VAT number

BG_VAT_NUMBER

Bulgarian VAT number

FR_VAT_NUMBER

French VAT number

BANK_ROUTING_TRANSIT_NUMBER

Bank routing transit number

BE_POSTAL_CODE

Belgian postal code

DE_POSTAL_CODE

German postal code

FR_POSTAL_CODE

French postal code

UK_POSTAL_CODE

UK postal code

US_POSTAL_CODE

US postal code

BEVERAGE

Type of beverage

BOOLEAN

Anwsers with the value True or False

CA_PROVINCE_TERRITORY

Canadian province

CA_PROVINCE_TERRITORY_CODE

Canadian province code

CITY

City name

CIVILITY

Civility

COLOR_HEX_CODE

Color hexadecimal code

COMPANY

Company name

CONTINENT

Continent name

CONTINENT_CODE

Continent code

COUNTRY

Country name

COUNTRY_CODE_ISO2

2-letter country code

COUNTRY_CODE_ISO3

3-letter country code

CURRENCY_CODE

Currency code

CURRENCY_NAME

Currency name

DECIMAL

Decimal numeric value

DE_PHONE

German phone number

FR_PHONE

French phone number

UK_PHONE

UK phone number

US_PHONE

US phone number

DATE

Date including day, month and year

EMAIL

Email address

EN_MONEY_AMOUNT

Amount of money in English format

FR_MONEY_AMOUNT

Amount of money in French format

EN_MONTH

Month in English

EN_MONTH_ABBREV

English month abbreviation

EN_WEEK_DAY

Week day or their abbreviation

FIRST_NAME

First name

LAST_NAME

Last name

FULL NAME

Full name

FR_CODE_COMMUNE_INSEE

French Insee code of cities with Corsica and colonies

FR_COMMUNE

French municipality

FR_DEPARTEMENT

French department

FR_REGION

French region

FR_REGION_LEGACY

Former French regions

FR_SSN

French social security number

SE_SSN

Swedish person number

UK_SSN

National identification number, national identity number, or national insurance number generally called NI number

US_SSN

US social security number

GENDER

Gender

GPS_COORDINATE

Google Maps style GPS decimal format

HR_DEPARTMENT

HR department

INDUSTRY

Industry name

INDUSTRY_GROUP

Industry group

INTEGER

Numeric value

IBAN

International Bank Account Number

IPv4_ADDRESS

IPv4 address

IPv6_ADDRESS

IPv6 address

ISBN_10

International standard book number 10 digits

ISBN_13

International standard book number 13 digits

JOB_TITLE

Job title

LANGUAGE

Language

LANGUAGE_CODE_ISO2

2-letter language code

LANGUAGE_CODE_ISO3

3-letter language code

LOCALIZATION

Localization

LOCATION_COORDINATE

Latitude and longitude coordinates separated by a comma in the form: N 0:59:59.99,E 0:59:59.99

MAC_ADDRESS

MAC address

MASTERCARD

Mastercard credit card

MEASURE_UNIT

Measure unit

MONTH

Month

MUSEUM

Museum name

MX_ESTADO

Mexican state

MX_ESTADO_CODE

Mexican state code

ORGANIZATION

Organization

PASSPORT

Passport number

SECTOR

Sector

SEDOL

Stock exchange daily official list

STREET_TYPE

Street type

TEXT

String text

URL

Web site URL

US_COUNTY

US county name

US_CREDIT_CARD

US American Express credit card

US_STATE

US states

US_STATE_CODE

US state code

VISACARD

Visa credit card

WEB_DOMAIN

Web site domain

WEEKDAY

Day of the week