Base datatype

Max limit/Range

Formats/Units supported

Number

23 digits

All formats

Text

-

(?s).*

Decimal

38 precision and 15 scale

where,

1. Precision is the number of digits in a number. Of the 38, maximum 23 digits can be placed to the left of the decimal point.

2. Scale is the number of digits after the decimal point.

All formats

Date

1-1-1000 to 9-9-9999 

dd MMM, yyyy 

Click here to know more. 

Date-time

1-1-1000 00:00:00 to 9-9-9999 23:59:59

dd MMM, yyyy hh:mm:ss Click here to know more.

Derived datatype

Derived from

Max limit

Formats/Units supported

Currency

Decimal

38 precision and 15 scale

where,

1. Precision is the number of digits in a number. Of the 38, maximum 23 digits can be placed to the left of the decimal point. 

2. Scale is the number of digits after the decimal point.

£,$,₩,₨,﷼. Click here to know more.

Temperature

Decimal

38 precision and 15 scale

where,

1. Precision is the number of digits in a number. Of the 38, maximum 23 digits can be placed to the left of the decimal point.

2. Scale is the number of digits after the decimal point.

°C, °F, K

Note: A base unit is the fundamental unit in a system of measurement. In DataPrep, conversions between different units and the histogram representation of data distribution is applied on top of the base unit. For example, for the Temperature datatype, the base unit is celcius (°C).

List

Text

-

Array

Example: ["North", "South", "East", "West"]

Map

Text

-

Object

Example: {"Region":"North", "Product":"Furniture", "Customer Name":"John Brito", "Sales":"272"}

Boolean

Text

-

Yes, No, True, False

URL

Text

-

protocol://domain/path#locationhash?paramname=paramvalues

Example: https://help.zoho.com/portal/en/kb/dataprep

Email

Text

-

username@domain

A valid email address consists of an email prefix and an email domain.

The prefix appears to the left of the @ symbol and the domain at right.

Email prefix:

1. Allowed characters: letters (a-z), numbers, underscores, periods, and dashes.

2. An underscore, period, or dash must be followed by one or more letter or number.

Email domain:

1. Allowed characters: letters, numbers, dashes.

2. The last portion of the domain must be at least two characters. For example: .com, .org, .cc

Length

Decimal

38 precision and 15 scale

where,

1. Precision is the number of digits in a number. Of the 38, maximum 23 digits can be placed to the left of the decimal point. 

2. Scale is the number of digits after the decimal point.

cm, m, km, mm, mi, µm, nm, ft, yd, in, nmi

Note: A base unit is the fundamental unit in a system of measurement. In DataPrep, conversions between different units and the histogram representation of data distribution is applied on top of the base unit. For example, for the Length datatype, the base unit is meter (m). 

Positive Number

Number

23 digits

N>=0

where N is the number.

Percentage 

Decimal

38 precision and 15 scale

where,

1. Precision is the number of digits in a number. Of the 38, maximum 23 digits can be placed to the left of the decimal point.

2. Scale is the number of digits after the decimal point.

%

Timestamp

Datetime

-

millis 

Example: 1635509077

Number of milliseconds calculated since January 1, 1970 , 00:00:00 GMT. A negative number is the number of milliseconds before this date.