Menu
Download Free Trial

Get field in Drag Dimensions Area automatically with JSON data like CSV

 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.

4 answers

Public
Roman Petrusha Flexmonster 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

Public
Quan Hieu 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? 

Public
Roman Petrusha Flexmonster 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?

Public
Quan Hieu December 15, 2016

Ok, thanks Roman.

Please login or Register to Submit Answer