asked on December 14, 2016
Hi team,
For example: I have the json data like this. So currently if I do not define the data type for a field, here is "Color", so the remaining will be like this.
{
"Country":{type: "level", hierarchy: "Geography",
level: "Country"},
"State": {type: "level", hierarchy: "Geography",
level: "State", parent: "Country"},
"City": {type: "level", hierarchy: "Geography",
parent: "State"},
"Price": {type: "number"},
"Quantity": {type: "number"}
}
Then in Drag Dimensions Area of Pivot Table, I can not see this column.
Do we have any way to show these field dynamically without predefine the data type in JSON like CSV
Many thanks.
⋅ December 14, 2016
Dear Quan Hieu,
Yes, you have to define all fields in the meta object or don't use it at all.
Do you have any problem with defining types?
Thanks,
Roman
⋅ December 14, 2016
Yes, It would be great if it is generated automatically, so if you have too much column in the Json, you don't need to spend to much time for it.
Thanks Roman. Could you help me with this question also? I really need to know if the tool could support me to do like my question or not?
⋅ December 15, 2016
If you have too many columns and don't want to define types for all of them you can leave them empty like this:
{
"Color": {},
"Price": {type: “number”}
}
The appropriate type will be defined automatically.
Does it help?
⋅ December 15, 2016
Ok, thanks Roman.