Alteryx Designer Cloud
ID alteryxdesignercloud
other
Alteryx Designer Cloud, formerly Trifacta, is a cloud service for data preparation. It infers a data type for each column from the first rows of a sample, shows the share of valid, invalid and empty values, and suggests transformations to fix the invalid ones. Besides logical types such as Integer, Boolean and Datetime it has complex types, which are strings checked by regular expressions, such as Social Security Number, Phone Number, Zip Code, State, Credit Card and HTTP Code. The types are listed in the overview of the type system in the Alteryx help.
- Website
- https://help.alteryx.com/trifacta-classic/en/concepts/feature-overviews/overview-of-the-type-system.html
- Supported types
- 13
Supported semantic types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| bankcard | Bank card (credit/debit card) PII | pii, finances | global | A bank card is typically a plastic card issued by a bank to its clients that performs one or more of a number of services that relate to... |
| boolean | Boolean | common | global | In computer science, the Boolean data type is a data type that has one of two possible values (usually denoted true and false) which is... |
| date | Date | datetime | global | Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype. |
| datetime | Date and time | datetime | global | Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an... |
| Email address PII | common, internet, pii | global | Address of an electronic mailbox in the form local-part@domain, defined in section 3.4.1 of RFC 5322. The local part names the mailbox,... | |
| gender | Gender PII draft | pii, persons | global | Gender flag and/or any other identification value |
| http_status_code | HTTP status code draft | internet | global | Three-digit code with which an HTTP server reports the result of a request. The first digit gives the class: 1xx informational, 2xx... |
| ipv4 | IPv4 address PII | internet, pii | global | 32-bit address of Internet Protocol version 4 (RFC 791), written in dotted-decimal notation as four numbers from 0 to 255, such as... |
| nanpphone | North American phone number (NANP) PII pattern draft | pii, common, telecom | US, CA | Ten-digit telephone number of the North American Numbering Plan (NANP), the shared numbering plan of country code 1 used by the United... |
| url | Uniform Resource Locator (URL) | common, internet | global | Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query... |
| usssn | US Social Security Number PII | pii, persons | US | In the United States, a Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary... |
| usstate | US State draft | geo | US | Name or code of US State |
| uszipcode | US Postal code PII pattern | geo | US | A ZIP Code is a postal code used by the United States Postal Service (USPS). Introduced in 1963, the basic format consisted of five... |
Use this record
- JSON: API v1 · legacy shape
- Improve it: edit
data/tools/other/alteryxdesignercloud.yamlon GitHub