Flat grid auto transform string column to number column


in the attached example I have a datasource with two fields, one of a numeric type and one of a text type; when I run with flat type column YEAR, it’s transformed into a numerical value and the sum is calculated!!
Instead in the other types of grid the YEAR column is treated as a string, and therefore correctly.
How is it possible? Where am I doing wrong?
Thank you very much!


1 answer

WebDataRocks Team WebDataRocks October 8, 2019


If the data type is not specified, then WebDataRocks automatically interprets the data type of each field and as a result, numbers that are surrounded by quotes may be read as numbers instead of strings.
For such cases, we suggest specifying the data type in the JSON meta object for the fields.
Please see the following guide: https://www.webdatarocks.com/doc/data-types-in-json/

Hope this helps.

Best Regards,
The WebDataRocks Team