Field format in database changes in Knowage Dataset

Question

Hello,

i'm having an issue with fields formats. some string fields from my collections in mongodb database become numeric fields in knowage query  dataset, with ".0" at the end. Is there a way to prevent this?

here is an example of the issue:

values in collection:                               

    Values in Knowage Dataset:                                 

Answer 1

Hi omaruane,

seems like the column is being cast to a float number and this is the basic knowage representation for float numbers.
If you want to keep the field as a number but you want to change the visible format inside a cockpit table just go to the dataset view inside the widget editor.
Select the column "day" and click on the paintbrush button to get inside the style panel.
There you should find the format you want without decimal values.

Otherwise you can change the data format you get to "string" or to a common date format and you should see it correctly.

Regards