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 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 |