This section provides information on supported data types in Designer Cloud.
Designer Cloud supports the following data types.
Tip
Transforms that include functions work only if the inputs are of a data type and format valid for the function. You should clean up the type and format of your columns before you apply transformations to them.
Item | Description |
|---|---|
Any non-null value can be typed as String. A String can be anything. | |
The Integer data type applies to positive and negative numeric values that have no decimal point. | |
Decimal data type applies to floating points up to 15 digits in length.
| |
The Boolean data type expresses true or false values. | |
This data type is applied to numeric data following the pattern for United States Social Security numbers. | |
This data type is applied to numeric data following common patterns that express telephone numbers and known valid phone numbers in the United States. | |
This data type matches text values that are properly formatted email addresses. | |
Credit card numbers are numeric data that follow the 14-digit or 16-digit patterns for credit cards. | |
This data type matches a variety of text patterns for expressing male/female distinctions. | |
This data type matches five- and nine-digit U.S. zipcode patterns. | |
State data type is applied to data that uses the full names or the two-letter abbreviations for states in the United States. | |
An Object data type is a method for encoding key-value pairs. A single field value may contain one or more sets of key-value pairs. | |
An array is a list of values grouped into a single value. An array may be of variable length; in one record the array field may contain two elements, while in the next record, it contains six elements. | |
The IP Address data type supports IPv4 address. | |
URL data type is applied to data that follows generalized patterns of URLs. | |
Values of these data types are three-digit numeric values, which correspond to recognized HTTP Status Codes. | |
Designer Cloud supports a variety of Datetime formats, each of which has additional variations to it. |