How to specify the data type for particular column?

Hello,
 
Thank you for reaching out to us.
 
Specific types for hierarchies can be defined using the meta-object of the JSON or CSV data source. Such an object is represented as the first element of an array for JSON or the first row for CSV.
 
In case your data source is JSON, it is also possible to use the meta-object in order to create multi-level hierarchies and defining specific captions of the hierarchies.
 
We would like to kindly draw your attention to the following code snippets demonstrating the type definition:
JSON:

[{
  "Category": {
    type: "string"
  },
  "Item": {
    type: "string"
  },
  "Serving Size": {
    type: "string"
  },
  "Calories": {
    type: "number"
  },
  "Calories from Fat": {
    type: "number"
  }
},
{
  "Category": "meat",
  "Item": "steak",
  "Serving Size": "300g",
  "Calories": 1300,
  "Calories from Fat": 750
}
...
]

 
CSV:

Invoice Number, D+Invoice Date, -Quantity, -Unit Price, +Country, w+Week Day
43111, 2018-05-15, 3, 329, France, Tuesday
43112, 2018-05-16, 4, 139, Italy, Wednesday

 
More information about the meta-object and data types in our documentation:

• For JSON
• For CSV

We hope it helps.
 
Best regards,
WebDataRocks Team

Thanks for answering.. It was helpful.