Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

How to show Array as field

Answered
Ivan Firoavanti asked on March 18, 2020

Is it possible to simply show the value of an array in the Pivot? https://jsfiddle.net/61fnov4d/
Thanks,
Ivan

1 answer

Public
Vera Didenko Flexmonster March 19, 2020

Hello, Ivan,
 
Thank you for writing to us and for providing a JSFiddle for illustration.
 
We would like to explain that Flexmonster supports two JSON formats:
 
1) An array of objects, where each object is an unordered set of name/value pairs
2) An array of arrays, where each sub-array contains ordered values.
 
More information about supported JSON formats can be found in our connecting to JSON guide.
 
 
Our team kindly suggests restructuring the JSON data the following way:

{
"Category": "Accessories",
"Color": "green",
"Quantity": 22,
"Test": "A"
},
{
"Category": "Accessories",
"Color": "green",
"Quantity": 22,
"Test": "B"
}

Here is a modified version of the JSFiddle showing the described approach: https://jsfiddle.net/flexmonster/sow71m4v/
 
 
Please let us know if this works and if you have any additional questions.
 
Best regards,
Vera

Please login or Register to Submit Answer