Data Types

1 Minute to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Field Attributes and Properties

Property	Property window	Possible Values	Comments
FieldType	DataType	String / Integer / Long(Integer) / Double / Date / DateTime	FieldType determines which operations can be performed on the field. FieldTypes are indicated in the solution explorer via symbols, and are listed in the properties window.
FieldSize	-	Low / Med / High / Continuous	Used in Script Editor by File Importer. See table below for mapping to JSON DataSize parameters.
DataSize	DataSize	Byte / Short / Integer / LongInteger / Double / [Custom] / Variable	A single FieldType can have a range of DataSizes, depending on the amount of data stored for the field. It is possible for the DataSize of a field to change if the underlying data changes (for example, a Short could be changed to an Integer)
DataType	Type	Discrete / Continuous	Some functions and operations are restricted by DataType. Previews and statistics are generally not available for fields with Continuous DataType. DateTime fields are continuous. Primary key fields are often continuous. It is possible for a DataType to change if the dimensions (number of discrete values) for the field changes. Depending on the data, it is sometimes possible to transform a field that has been loaded as CONTINUOUS into a DISCRETE DataType.

FieldTypes and Symbols

Symbol	Field Type
	String
	Integer
	LongInteger / Long
	Double
	Date
	DateTime
	Field is used in a link/join
	Key Field
	DataSet

DataType Limits

Field Type		Data Load JSON			Limits
type	size	DataType	FieldType	DataSize	Min	Unique Values	Note
String	Low	DISCRETE	STRING	BYTE		250	String field with up to 250 unique values
String	Med	DISCRETE	STRING	SHORT		65530	String field with up to 65,530 unique values
String	High	DISCRETE	STRING	INTEGER		1,000,000	String field with up to 1,000,000 unique values
String	Continuous	CONTINUOUS	STRING	[Length]			String field with large unknown number of unique values
String	Variable	CONTINUOUS	STRING	[Variable]			String field with any number of unique values
Integer	Low	DISCRETE	INTEGER	BYTE		250	Integer field with up to 250 unique values
Integer	Med	DISCRETE	INTEGER	SHORT		65530	Integer field with up to 65,530 unique values
Integer	High	DISCRETE	INTEGER	INTEGER		1000000	Integer field with up to 1,000,000 unique values
Integer	Continuous	CONTINUOUS	INTEGER	INTEGER			Integer field with large unknown number of unique values
Long	Low	DISCRETE	LONGINTEGER	BYTE		250	Big Integer field with up to 250 unique values (Use if number > 2 billion or < -2 Billion)
Long	Med	DISCRETE	LONGINTEGER	SHORT		65530	Big Integer field with up to 65,530 unique values
Long	High	DISCRETE	LONGINTEGER	INTEGER		100000	Big Integer field with up to 1,000,000 unique values
Long	Continuous	CONTINUOUS	LONGINTEGER	LONGINTEGER			Big Integer field with up large unknown number of unique values
Double	Med	DISCRETE	DOUBLE	SHORT		655530	Floating point field with up to 65,530 unique values (Non-integer numerics)
Double	High	DISCRETE	DOUBLE	INTEGER		1000000	Floating point field with up to 1,000,000 unique values
Double	Continuous	CONTINUOUS	DOUBLE	DOUBLE			Floating point field with large unknown number of unique values
Date		DISCRETE	DATE	SHORT			Date Field
DateTime		CONTINUOUS	DATETIME				Date Time Field

Note: Not much overhead in using a long rather than an integer unless dealing with continuous fields.

Supported Date Field Formats

• YYYY-MM-DD

• YYYYMMDD

• MM-DD-YYYY

• MMDDYYYY

• DD-MM-YYYY

• DDMMYYYY

• M-D-Y

Date Formats

Note that separators are flexible. YYYY/MM/DD is equivalent to YYYY-MM-DD.

Was this article helpful?

What's Next

DataView

Table of contents

Field Attributes and Properties
FieldTypes and Symbols
DataType Limits