...
These data types have no additional specification requirements:
| Data Type | Description | ||||||
|---|---|---|---|---|---|---|---|
| String Data Type |
| ||||||
| Integer Data Type |
| ||||||
| Decimal Data Type |
| ||||||
| Boolean Data Type |
| ||||||
| Datetime Data Type |
| ||||||
| Object Data Type |
| ||||||
| Array Data Type |
|
Formatting differences may apply. For example,
may recognize D s product Y and N as Boolean data type, while other systems may not.
...
The following are the complex data types supported by
| D s product |
|---|
| Data Type | Description | ||||||
|---|---|---|---|---|---|---|---|
| Social Security Number Data Type |
| ||||||
| Phone Number Data Type |
| ||||||
| Email Address Data Type |
| ||||||
| Credit Card Data Type |
| ||||||
| Gender Data Type |
| ||||||
| Zip Code Data Type |
| ||||||
| State Data Type |
| ||||||
| IP Address Data Type |
| ||||||
| URL Data Type |
| ||||||
| HTTP Code Data Type |
|
Complex data types are typically defined based on a regular expression applied to String values. For example, the following regex is used to define the accepted values for the Email Address data type:
...
Logical and complex data types
| Data type | Category | Internal data type | Notes |
|---|---|---|---|
| String Data Type | logical | String | The default data type. Any non-empty/non-value is valid for String data type. |
| Integer Data Type | logical | Int | Use NUMFORMAT Function to format these values. Underlying values are not modified. |
| Decimal Data Type | logical | Float | Use NUMFORMAT Function to format these values. Underlying values are not modified. |
| Boolean Data Type | logical | Bool | |
| Datetime Data Type | logical | Datetime | Use DATEFORMAT Function to format these values. Underlying values are not modified. |
| Object Data Type | logical | Map/Object | |
| Array Data Type | logical | Array | |
| Social Security Number Data Type | complex | String | String data type constrained by a regular expression. |
| Phone Number Data Type | complex | String | String data type constrained by a regular expression. |
| Email Address Data Type | complex | String | String data type constrained by a regular expression. |
| Credit Card Data Type | complex | String | String data type constrained by a regular expression. |
| Gender Data Type | complex | String | String data type constrained by a regular expression. |
| Zip Code Data Type | complex | String | String data type constrained by a regular expression. |
| State Data Type | complex | String | String data type constrained by a regular expression. |
| IP Address Data Type | complex | String | String data type constrained by a regular expression. |
| URL Data Type | complex | String | String data type constrained by a regular expression. |
| HTTP Code Data Type | complex | String | String data type constrained by a regular expression. |
Types in Source Data
Depending on the source system, imported data may be typed to
| D s item | ||
|---|---|---|
|
...
| Info | |
|---|---|
NOTE: When you apply a formatting function to a column, the data appears in the specified format in the
|
| Formatting Function | Applicable Data Type | Description | ||||||
|---|---|---|---|---|---|---|---|---|
| NUMFORMAT Function | Integer, Decimal |
| ||||||
| DATEFORMAT Function | Datetime |
| ||||||
| UNIXTIMEFORMAT Function | Datetime |
|
Type functions
The
provides a set of functions for managing types. D s webapp
...
These functions can be used to test for valid or invalid values against a specific data type.
| Function | Description | ||||||
|---|---|---|---|---|---|---|---|
| VALID Function |
| ||||||
| ISMISMATCHED Function |
| ||||||
| IFVALID Function |
| ||||||
| IFMISMATCHED Function |
|
Parsing functions
These functions can be used to parse String values against a specific data type.
| Function | Description | ||||||
|---|---|---|---|---|---|---|---|
| PARSEINT Function |
| ||||||
| PARSEFLOAT Function |
| ||||||
| PARSEBOOL Function |
| ||||||
| PARSEDATE Function |
| ||||||
| PARSEARRAY Function |
| ||||||
| PARSEOBJECT Function |
| ||||||
| PARSESTRING Function |
|
Managing null and empty values
These functions allow you to generate or test for missing or null values.
| Function | Description | ||||||
|---|---|---|---|---|---|---|---|
| ISNULL Function |
| ||||||
| NULL Function |
| ||||||
| IFNULL Function |
| ||||||
| ISMISSING Function |
| ||||||
| IFMISSING Function |
|
Type Conversions on Export
...
