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!
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.
The WebDataRocks Team