Convert Data Field Types with Functions

Each column in a Datameer workbook is assigned a specific data type. Particular criteria is required for data to fall into a data type category. When using your data within workbooks, certain Datameer functions only work with certain types of data. Also, certain functions return only a specific type of data.

These data types aren't fixed and can be changed within a workbook to fit your needs.

Convert Data Type Functions

Original data type	Desired data type	Function

Original data type	Desired data type	Function
String	Integer	INT
String	Float	FLOAT
String	Date	ASDATE
Integer	String	T
Integer	Date	MSTODATE
Integer	Big Integer	BIGINTEGER
Integer	Big Float	BIGDECIMAL
Float	Integer	INT
Float	String	T
Float	Big Integer	BIGINTEGER
Float	Big Float	BIGDECIMAL
Date	String	FORMATDATE
Date	Integer	TIMESTAMP
List	String (JSON)	TOJSON
Any type	List	LIST