Predefined Semantic Types
When you add a dataset, Talend Data Preparation automatically suggests one of the supported semantic types for each column.
If you export and reimport a semantic type, or if you edit it, it becomes a custom semantic type and it won't be updated when Talend improves it.
The table below lists all the supported semantic types.
Standard type | Description |
---|---|
Text | String text |
Integer | Numeric value |
Decimal | Decimal numeric value |
Date | Date including day, month and year |
Time | Time of the day |
Timestamps | Date and time |
Boolean | Answers with the value True or False |
Semantic type | Description | Origin of data | Example |
---|---|---|---|
Academic and professional suffix | Academic and professional suffix | Talend | Ph.D. |
Academic and professional title | Academic and professional title | Talend | Professor |
Address Line | Street number and name You cannot visualize or edit this semantic type. |
Talend | 101 Independence Avenue |
Airport | Airport | Talend | Charles de Gaulle Airport |
Airport Code | Airport code | Talend | CDG |
Amex Card | American Express card | Talend | 3759 875543 21000 |
Animal | Animal | Talend | cat |
Answer | Answers with the value True or False | Talend | Yes |
AT VAT Number | Austrian VAT number | Talend | AT12345678 |
Bank Routing Transit Number | Bank routing transit number | Talend | 801234567 |
BE Postal Code | Belgian postal code | Talend | 1000 |
Beverage | Type of beverage | YAGO | tea |
BG VAT Number | Bulgarian VAT number | Talend | BG1234567891 |
CA Province Territory | Canadian province | Stadoids | Quebec |
CA Province Territory Code | Canadian province code | Stadoids | QC |
Christian religious title | Christian religious title | Talend | Brother |
Civility | Civility | Talend | MRS |
Color Hex Code | Color hexadecimal code | Talend | #Ab1Cd2 |
Company | Company name | YAGO | Talend |
Continent | Continent name | Talend | europe |
Continent Code | Continent code | Talend | EUR |
Country | Country name | ISO OBP | France |
Country Code ISO2 | 2-letter country code | ISO OBP | FR |
Country Code ISO3 | 3-letter country code | ISO OBP | FRA |
Currency Code | Currency code | ISO OBP Currency codes | EUR |
Currency Name | Currency name | ISO OBP Currency codes | Euro |
Data URL | URL starting with the word data | Talend | data:text/html,%3Cscript%3Ealert%28%27hi%27%29%3B%3C%2Fscript%3E |
DE Postal Code | German postal code | Talend | 20038 |
DE Phone | German phone number | Talend | 00492 23456789 |
Email address | Talend | username@email.com | |
EN Month | Month in English | Talend | January |
EN Month Abbrev | English month abbreviation | Talend | Jan |
EN Weekday | Week day or their abbreviation | Talend | Wednesday |
First Name | First name | Talend | John |
File URL | File URL | Talend | file://host/path |
Formal title | Formal title | Talend | Madam |
FR Postal Code | French postal code | Talend | 44000 |
FR VAT Number | French VAT number | Talend | FRAB 123456789 |
FR Phone | French phone number | Talend | 0601020304 |
FR Insee Code | French Insee code of cities with Corsica and colonies | Insee | FRA-53970 |
FR Commune | French municipality | Insee | Laval |
FR Departement | French department | Insee | Mayenne |
FR Region | French region | Insee | Pays de la Loire |
FR Region Legacy | Former French regions, prior to the 2016 territorial reform. | Insee | Nord-Pas-De-Calais |
FR Social Security Number | French social security number | Talend | 1 23 45 67 891 234 56 |
Full Name | Full name You cannot visualize or edit this semantic type. |
Talend | John Doe |
Gender | Gender | Talend | Female |
Generic URL | Generic URL (Web, HDFS, MailTo, data, file) | Talend | data:text/html,%3Cscript%3Ealert%28%27hi%27%29%3B%3C%2Fscript%3E |
Geographic Coordinate | Geographic coordinate, longitude or latitude coordinates with at least meter precision | Talend | -171.12345 |
Geographic Coordinates | Geographic coordinates, Google Maps style GPS Decimal format | Talend | 47.986206, -0.782563 |
Geographic Coordinates (degree) | Geographic coordinates (degrees), Latitude and longitude coordinates separated by a comma. | Talend | N 0:59:59.99,E 0:59:59.99 |
HDFS URL | HDFS URL | Talend | hdfs://data/users.csv |
HR Department | HR department | Talend | marketing |
Industry | Industry name | Talend | Real Estate |
Industry Group | Industry group | Talend | Media |
Inherited suffix | Inherited suffix | Talend | Jr. |
Islamic religious title | Islamic religious title | Talend | Sharif |
IBAN | International Bank Account Number | Talend | AB12 1234 ABCD 1AB2 B2A1A1B2 |
IPv4 Address | IPv4 address | Talend | 255.0.0.0 |
IPv6 Address | IPv6 address | Talend | 2001:db8:3333:4444:5555:6666:7777:8888 |
ISBN-10 | International standard book number 10 digits | Talend | ISBN-10: 1-2345-6789-1 |
ISBN-13 | International standard book number 13 digits | Talend | ISBN-13: 979-1-23456-789-6 |
Job Title | Job title | Talend | translator |
Judaic religious title | Judaic religious title | Talend | Rabbi |
Language | Language | Wikipedia | French |
Language Code ISO2 | 2-letter language code | Wikipedia | fr |
Language Code ISO3 | 3-letter language code | Wikipedia | fra |
Last Name | Last name | United States Census Bureau | Doe |
Measure Unit | Measure unit | Talend | Celsius |
MailTo URL | MailTo URL | Talend | mailto:word@mail.com?subject=sender@mail.com&sender2@mail.com |
Military suffix | Military suffix | Talend | USN |
Money Amount (EN) | Amount of money in English format | Talend | $12.34 |
Money Amount (FR) | Amount of money in French format | Talend | 12,34 € |
MAC Address | MAC address | Talend | 1a:2b:3C:4D:5e:A1 |
MasterCard | Mastercard credit card | Talend | 5412345678912345 |
Month | Month | Talend | July |
Museum | Museum name | YAGO | Museum of London |
MX Estado | Mexican state | http://www.statoids.com/ | Chihuahua |
MX Estado Code | Mexican state code | Statoids | CHH |
Name Suffix | Name suffix (Inherited, academic, professional or military) | Talend | BA |
North American state | US state and Canadian province | Talend | New York |
North American state code | US state code and Canadian province code | Talend | NY |
Organization | Organization | YAGO | Kenya Wildlife Service |
Sector | Sector | Talend | Health Care |
Passport | Passport number | Talend | 1234567891AAA1234567A1234567ABCDEFGHIJKLMN12 |
Phone number | Phone number (DE, FR, UK, US) | Talend | 0201020304 |
Religious title | Religious title (Christian, Islamic, Judaic) | Talend | Pastor |
SE Social Security Number | Swedish person number | Talend | 19960110-5678 |
SEDOL | Stock exchange daily official list | Talend | 0123456 |
Street Type | Street type | Talend | Avenue |
Title | Title (Civility, academic, professional, formal, religious) | Talend | Mister |
UK Phone | UK phone number | Talend | tel:+44 123 456 7891 |
UK Postal Code | UK postal code | Talend | SO15 2GB |
UK Social Security Number | National identification number, national identity number, or national insurance number generally called NI number | Talend | AT123456A |
US Phone | US phone number | Talend | +1-650-513-0514 |
US Postal Code | US postal code | Talend | 12345-6789 |
US Social Security Number | US social security number | Talend | 123-45-6789 |
URL | Web site URL | Talend | www.qlik.com |
US County | US county name | Wikipedia | Durham |
US State | US states | Talend | Alaska |
US State Code | US state code | Talend | AL |
Visa Card | Visa credit card | Talend | 4970 0021 0394 |
Web Domain | Web site domain | Talend | www.qlik.com |
Weekday | Day of the week | Talend | Saturday |