Predefined Semantic Types - 2.3

Talend Data Preparation User 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

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

Airport

Airport name

Airport Code

Airport code

Amex Card

American Express credit card

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

Phone

Phone number. Includes german, french, british and american phone numbers.

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 Codigo

Mexican state code

NA State

North American states. Includes Mexican, Canadian and American states.

NA State Code

North American state codes. Includes Mexican, Canadian and American state codes.

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 State

US states

US State Code

US state code

Visa Card

Visa credit card

Web Domain

Web site domain

Weekday

Day of the week