Convert Data Field Types with Functions

Each column in a Datameer X 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 X 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 typeDesired data typeFunction
StringIntegerINT
StringFloatFLOAT
StringDateASDATE
IntegerStringT
IntegerDateMSTODATE
IntegerBig IntegerBIGINTEGER
IntegerBig FloatBIGDECIMAL
FloatIntegerINT
FloatStringT
FloatBig Integer BIGINTEGER
FloatBig Float BIGDECIMAL
DateStringFORMATDATE
DateIntegerTIMESTAMP
ListString (JSON)TOJSON
Any typeListLIST