Trifacta® 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.
For more information on how to explicitly reference these data types in your steps, see Valid Data Type Strings.
String Data Type
Any non-null value can be typed as String. A String can be anything.
See String Data Type.
Integer Data Type
The Integer data type applies to positive and negative numeric values that have no decimal point.
See Integer Data Type.
Decimal Data Type
Decimal data type applies to floating points up to 15 digits in length.
See Decimal Data Type.
Boolean Data Type
The Boolean data type expresses true or false values.
See Boolean Data Type.
Social Security Number Data Type
This data type is applied to numeric data following the pattern for United States Social Security numbers.
See Social Security Number Data Type.
Phone Number Data Type
This data type is applied to numeric data following common patterns that express telephone numbers.
See Phone Number Data Type.
Email Address Data Type
This data type matches text values that are properly formatted email addresses.
See Email Address Data Type.
Credit Card Data Type
Credit card numbers are numeric data that follow the 14-digit or 16-digit patterns for credit cards.
See Credit Card Data Type.
Gender Data Type
This data type matches a variety of text patterns for expressing male/female distinctions.
See Gender Data Type.
Zip Code Data Type
This data type matches five- and nine-digit U.S. zipcode patterns.
See Zip Code Data Type.
State Data Type
State data type is applied to data that uses the full names or the two-letter abbreviations for states in the United States.
See State Data Type.
Object Data Type
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.
See Object Data Type.
Array Data Type
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.
See Array Data Type.
IP Address Data Type
The IP Address data type supports IPv4 address.
See IP Address Data Type.
URL Data Type
URL data type is applied to data that follows generalized patterns of URLs.
See URL Data Type.
HTTP Code Data Type
Values of these data types are three-digit numeric values, which correspond to recognized HTTP Status Codes.
See HTTP Code Data Type.
Datetime Data Type
Trifacta® supports a variety of Datetime formats, each of which has additional variations to it.
See Datetime Data Type.
If you have created a custom type, it is available for selection from the column type drop-down.
NOTE: After a custom type has been created, a platform restart is required. Please contact your Trifacta administrator.
- A custom type can be created based on a dictionary file. If a value is contained in the type's dictionary, the value is considered valid. See Create Custom Data Types.
- Developers may also define custom data types using regular expressions. See Create Custom Data Types Using RegEx.
This page has no comments.