You are here: Reference > Data Field Types

Data Types

Alteryx uses many data types. The data type for a value determines how that data should be processed.

A data type can be specified in a Select tool or any tool with an embedded select (Append Fields, Join, Join Multiple, Find Nearest and Spatial Match).

The data type drop-down list shows the incoming field type and a fieldtype: Forced option. By specifying the forced field type a macro author can ensure the incoming data type will always be the type they expect.

Strings

A string represents alphanumeric data and can include letters, numbers, spaces, or other types of characters. A string can also be thought of as plain text. All the characters in a string are considered text even if the characters are digits.

While a string may contain text that looks like a number (for example, "123.4"), it must first be converted to a numeric data type (either with a Select tool, or with the ToNumber Functions) to perform calculations.

Type Description Example
String Fixed Length String. The length should be at least as large as the largest character value contained in the field or values may be truncated. Limited to 8192 characters. Any string whose length does not vary much from value to value, and only contains simple ASCII characters.
WString Wide String will accept Unicode characters. Limited to 8192 characters. Any string whose length does not vary much from value to value and contains Unicode characters.
V_String Variable Length. The length of the field will adjust to accommodate the entire string within the field. Any string whose length varies from value to value, and only contains simple ASCII characters.
V_WString Variable Length Wide String. The length of the field will adjust to accommodate the entire string within the field and will accept Unicode characters.

Any string whose length varies from value to value and contains Unicode characters.

Numeric Data

There are several different numeric data types including integers, decimals, floats, and doubles. Numeric data types do not have adjustable lengths except for Fixed Decimal.

Type Description Example
Byte A unit of data that is 8 binary digits (bits) long. A byte field is a positive whole number that falls within the range 0 thru 255, or 28 0, 1, 2, 3....253, 254, 255
Int16

A numeric value without a decimal equal to 2 bytes, or -(215) to (215)-1

–32,768 to 32,767
Int32 A numeric value without a decimal equal to 4 bytes, or -(231) to (231)-1 –2,147,483,648 to 2,147,483,647
Int64 A numeric value without a decimal equal to 8 bytes, or -(263) to (263)-1 –9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Fixed Decimal

A numeric value with a decimal.

The length (precision) of a fixed decimal is equal to the width of the integer (left side of decimal) plus the decimal point plus the width of the scale (right side of decimal). If a number is negative, the negative sign is also included in the length.

Alteryx defaults a Fixed Decimal to 19.6. The maximum precision is 50, inclusive of the decimal point and negative sign (if applicable).

A Fixed Decimal is the only numeric data type with an adjustable length.

A value of 1234.567 with a length of 7.2 results in 1234.57

A value of 1234.567 with a length of 7.3 results in a field conversion error and Null output, as the value does not fit within the specified precision.

A value of 1234.567 with a length of 6.1 results in 1234.6

A value of 1234.567 with a length of 8.3 results in 1234.567

A value of -1234.567 with a length of 8.3 results in a field conversion error and Null output, as the value does not fit within the specified precision.

A value of 1234.567 with a length of 11.6 results in 1234.567000

Float

A standard single precision floating point value. It uses 4 bytes, and can represent values from +/- 3.4 x 10-38 to 3.4 x 1038 with 7 digits of precision.

A float uses a decimal that can be placed in any position and is mainly used to save memory in large arrays of floating point numbers.

+/- 3.4 x 10-38 to 3.4 x 1038 with 7 digits precision
Double A standard double precision floating point value. It uses 8 bytes, and can represent values from +/- 1.7 x 10-308 to 1.7 x 10308 with 15 digits precision.

A double uses a decimal that can be placed in any position. A double uses twice as many bits as a float and is generally used as the default data type for decimal values.
+/- 1.7 x 10-308 to 1.7 x 10308 with 15 digits precision

Date/Time

Type Description Example
Date A 10 character String in "yyyy-mm-dd" format December 2, 2005 = 2005-12-02
Time A 8 character String in "hh:mm:ss" format

2:47 and 53 seconds a.m. = 02:47:53

2:47 and 53 seconds p.m. = 14:47:53

DateTime A 19 character String in "yyyy-mm-dd hh:mm:ss" format 2005-12-02 14:47:53

Boolean Data

Type Description Example
Bool An expression with only two possible values: True or False

The words 'True' and 'False' display in the results where 'False' = 0 and 'True' = non-zero.

Spatial Objects

Type Description Example
SpatialObj The spatial object associated with a data record. There can be multiple spatial object fields contained within a table. A spatial object can consist of a point, line, polyline, or polygon.