Dynamic Columns with Cross-Data Component

[paroxit]

Hi,

I have a JSON data like this example;

Code: Select all

{"items":[{"product":{"productId":2,"name":"DOUBLE"},"values":[{"productId":2,"coopId":1,"coopName":"KÜMES 1","value":0.0},{"productId":2,"coopId":2,"coopName":"KÜMES 2","value":13646.0},{"productId":2,"coopId":3,"coopName":"KÜMES 3","value":0.0},{"productId":2,"coopId":4,"coopName":"KÜMES 4","value":0.0},{"productId":2,"coopId":5,"coopName":"Kümes 1","value":0.0}]},{"product":{"productId":18,"name":"25'LİK MAVİ"},"values":[{"productId":18,"coopId":1,"coopName":"KÜMES 1","value":0.0},{"productId":18,"coopId":2,"coopName":"KÜMES 2","value":0.0},{"productId":18,"coopId":3,"coopName":"KÜMES 3","value":0.0},{"productId":18,"coopId":4,"coopName":"KÜMES 4","value":0.0},{"productId":18,"coopId":5,"coopName":"Kümes 1","value":0.0}]},{"product":{"productId":1,"name":"S.JUMBO"},"values":[{"productId":1,"coopId":1,"coopName":"KÜMES 1","value":0.0},{"productId":1,"coopId":2,"coopName":"KÜMES 2","value":5000.0},{"productId":1,"coopId":3,"coopName":"KÜMES 3","value":0.0},{"productId":1,"coopId":4,"coopName":"KÜMES 4","value":0.0},{"productId":1,"coopId":5,"coopName":"Kümes 1","value":0.0}]},{"product":{"productId":16,"name":"GÜBRE"},"values":[{"productId":16,"coopId":1,"coopName":"KÜMES 1","value":0.0},{"productId":16,"coopId":2,"coopName":"KÜMES 2","value":0.0},{"productId":16,"coopId":3,"coopName":"KÜMES 3","value":0.0},{"productId":16,"coopId":4,"coopName":"KÜMES 4","value":0.0},{"productId":16,"coopId":5,"coopName":"Kümes 1","value":0.0}]},{"product":{"productId":17,"name":"ESKİ ANA"},"values":[{"productId":17,"coopId":1,"coopName":"KÜMES 1","value":0.0},{"productId":17,"coopId":2,"coopName":"KÜMES 2","value":5878.0},{"productId":17,"coopId":3,"coopName":"KÜMES 3","value":0.0},{"productId":17,"coopId":4,"coopName":"KÜMES 4","value":0.0},{"productId":17,"coopId":5,"coopName":"Kümes 1","value":0.0}]},{"product":{"productId":4,"name":"Test"},"values":[{"productId":4,"coopId":3,"coopName":"KÜMES 3","value":0.0},{"productId":4,"coopId":4,"coopName":"KÜMES 4","value":0.0},{"productId":4,"coopId":5,"coopName":"Kümes 1","value":0.0},{"productId":4,"coopId":1,"coopName":"KÜMES 1","value":0.0},{"productId":4,"coopId":2,"coopName":"KÜMES 2","value":8958.0}]},{"product":{"productId":3,"name":"JUMBO"},"values":[{"productId":3,"coopId":2,"coopName":"KÜMES 2","value":26450.0},{"productId":3,"coopId":3,"coopName":"KÜMES 3","value":0.0},{"productId":3,"coopId":4,"coopName":"KÜMES 4","value":0.0},{"productId":3,"coopId":5,"coopName":"Kümes 1","value":0.0},{"productId":3,"coopId":1,"coopName":"KÜMES 1","value":0.0}]}]}

(Or you could examine data on jsoneditoronline.org : https://jsoneditoronline.org/#left=clou ... 94e5eb7ad5)

And I want to show them exactly like this;

SS-Stimulsoft.png (6.9 KiB) Viewed 528 times

But although I have searched everywhere in this forum, I cannot seem to wrap my head around cross-data relations.

How can I represent this data within this form ?

Could somebody please help me ?

Thanks in advance.

[Lech Kulikowski]

Hello,

You can use the Cross-Data component.

Thank you.