Predefined standard and data-detected classes
Availability-noteAWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
The tables below list all the standard and data-detected classes supported and
integrated by default in the application.
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 |
Data-detected class | Description | Origin of data |
---|---|---|
Address Line | Street number and name | Talend |
Airport | Airport | Talend |
Airport Code | Airport code | Talend |
Amex Card | American Express card | Talend |
Animal | Animal (multilingual) | Talend |
Answer | Answers with the value Yes or No (EN, FR, DE and ES) | Talend |
AT VAT Number | Austrian VAT number | Talend |
Bank Routing Transit Number | Bank routing transit number | Talend |
BE Postal Code | Belgian postal code | Talend |
Beverage | Type of beverage | Talend |
BG VAT Number | Bulgarian VAT number | Talend |
CA Province Territory | Canadian province | http://www.statoids.com/ |
CA Province Territory Code | Canadian province code | http://www.statoids.com/ |
City | City name (multilingual) | Talend |
Civility | Civility (multilingual) | Talend |
Color Hex Code | Color hexadecimal code | Talend |
Company | Company name | YAGO |
Continent | Continent name (multilingual) | Talend |
Continent Code | Continent code | Talend |
Country | Country name (EN and FR) | https://okfn.org/ (Public Domain Dedication and License) |
Country Code ISO2 | 2-letter country code | https://okfn.org/ (Public Domain Dedication and License) |
Country Code ISO3 | 3-letter country code | https://okfn.org/ (Public Domain Dedication and License) |
Currency Code | Currency code | https://okfn.org/ (Public Domain Dedication and License) |
Currency Name | Currency name | https://okfn.org/ (Public Domain Dedication and License) |
Data URL | URL starting with the word data | Talend |
DE Postal Code | German postal code | Talend |
DE Phone | German phone number | Talend |
Email address | Talend | |
EN Month | Month in English | Talend |
EN Month Abbrev | English month abbreviation | Talend |
EN Weekday | Week day or their abbreviation | Talend |
First Name | First name | Talend |
File URL | File URL | Talend |
FR Postal Code | French postal code | Talend |
FR VAT Number | French VAT number | Talend |
FR Phone | French phone number | Talend |
FR Insee Code | French Insee code of cities with Corsica and colonies | Insee |
FR Commune | French municipality | Insee |
FR Departement | French department | Insee |
FR Region | French region | Insee |
FR Region Legacy | Former French regions, prior to the 2016 territorial reform. | Insee |
FR Social Security Number | French social security number | Talend |
Full Name | Full name which contains CIVILITY keyword | Talend |
Gender | Gender (multilingual) | Talend |
Geographic Coordinate | Geographic coordinate, longitude or latitude coordinates with at least meter precision | Talend |
Geographic Coordinates | Geographic coordinates, Google Maps style GPS Decimal format | Talend |
Geographic Coordinates (degree) | Geographic coordinates (degrees), Latitude and longitude coordinates separated by a comma in the form: N 0:59:59.99,E 0:59:59.99 | Talend |
HDFS URL | HDFS URL | Talend |
HR Department | Department or service name in company | Talend |
Industry | Industry name | Talend |
Industry Group | Industry group | Talend |
IBAN | International Bank Account Number | Talend |
IPv4 Address | IPv4 address | Talend |
IPv6 Address | IPv6 address | Talend |
ISBN-10 | International standard book number 10 digits | Talend |
ISBN-13 | International standard book number 13 digits | Talend |
Job Title | Job title | Talend |
Language | Language | Wikipedia |
Language Code ISO2 | 2-letter language code | Wikipedia |
Language Code ISO3 | 3-letter language code | Wikipedia |
Last Name | Last name | United States Census Bureau |
Measure Unit | Measure unit | Talend |
MailTo URL | MailTo URL | Talend |
Money Amount (EN) | Amount of money in English format | Talend |
Money Amount (FR) | Amount of money in French format | Talend |
MAC Address | MAC address | Talend |
MasterCard | Mastercard credit card | Talend |
Month | Month (multilingual) | Talend |
Museum | Museum name | YAGO |
MX Estado | Mexican state | http://www.statoids.com/ |
MX Estado Code | Mexican state code | http://www.statoids.com/ |
Organization | Organization name | YAGO |
Sector | Economic sector name | Talend |
Passport | Passport number | Talend |
SE Social Security Number | Swedish person number | Talend |
SEDOL | Stock exchange daily official list | Talend |
Street Type | Street type (multilingual) | Talend |
UK Phone | UK phone number | Talend |
UK Postal Code | UK postal code | Talend |
UK Social Security Number | National identification number, national identity number, or national insurance number generally called NI number | Talend |
US Phone | US phone number | Talend |
US Postal Code | US postal code | Talend |
US Social Security Number | US social security number | Talend |
URL | Web site URL | Talend |
US County | US county name | Wikipedia |
US State | US states | Talend |
US State Code | US state code | Talend |
Visa Card | Visa credit card | Talend |
Web Domain | Web site domain | Talend |
Weekday | Day of the week (multilingual) | Talend |