Q&A BY TAG 'Type Conversion'

Hi, Context : -I have different documents within a collection in mongodb : - I have the collection with document A and document B - In the document A , I have an element "F1" of type "Array of objects" with sub-fileds "sub-Fi" - In do...

Type Conversion ARRAY Register Error Compound Types mongodb

Hi i want to acheive below in denodo. TO_CHAR(1210.73, '9999.9') Result: ' 1210.7' Where '9999.9' is value coming from my_table column name "format" and 1210.73 is value of my_table column name "o_ips" so basically it is select to_char(o_ips,form...

Type Conversion to_char

Hi everyone, I have some issues with data type conversion while using the MongoDB Custom Wrapper. The following example Data illustrates the issue. /* 1 */ { "_id" : ObjectId("5f22f0c2754d8395a9b0acb9"), "Id" : "00Qi000000Jr44XEAR", "Nam...

Type Conversion Custom Connector Data Type Conversion Error Handling mongodb

Hi, I am trying to create a Selection View in order to convert text value columns in a delimited file based data source to other data types, based on : https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base...

Type Conversion Delimited File text field